Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am trying to get the same output but I am getting wrong please help! The out should be the same as it the table

I am trying to get the same output but I am getting wrong please help!

image text in transcribedimage text in transcribed

The out should be the same as it the table below

image text in transcribed

14. Go to the August Advertising worksheet, which lists all the articles published in August. Jack wants to display the data by article type and then list the projects by publication date. Sort the data in the table in ascending order first by article type and then by publication date. 15. Jack also wants to calculate ad amount subtotals for each article type: a. Convert the table to a range. b. Insert a subtotal at each change in the Article Type value. c. Use the Sum function to calculate the subtotals. d. Add subtotals to the Ad Amt values only. e. Include a summary below the data. f. Collapse the outline to display only the subtotals for each article type and the grand total. A B C D E F G Publication Date Number of Words Article Type Sports Level Ad Amt 322 174 250 314 504 446 482 181 512 805 435 625 785 1,260 1,115 1,205 453 1,280 524 Article Title Author 1 2 Last-minute duel in golf Martin 3 European road bicycle racing? Pedraza 4 This year could be big in tennis Tovar 5 Third base is a power position O'Brien 6 Ups and downs in the NFC East Fuentes 7 Ranking NBA journeymen Romano 8 Fantasy baseball movers and shakers O'Brien 9 Women's softball championship Pedraza 10 Ups and downs in the NFC South Fuentes 11 Ups and downs in the NFC North Fuentes 12 Had enough with preseason football? Walsh 13 Ankle injuries are killing the NBA's best Romano 14 NFL waiver wire Fuentes 15 Major league baseball is for the young O'Brien 16 College football is around the corner Aken 17 Quarterback stability is everything Walsh 18 Women's soccer and more Tovar 19 Eleventh-inning errors O'Brien 20 Hernandez comes roaring back Martin 21 Pace of MLB rebuild picks up O'Brien 22 Time for another MLB expansion? Tovar 23 Head-to-head points and ranks Aken 24 New to fantasy baseball? Tovar 25 Closer trends and strategies O'Brien 26 Hidden college football stars Walsh 8/2/2021 8/5/2021 8/7/2021 8/8/2021 8/10/2021 8/10/2021 8/11/2021 8/12/2021 8/12/2021 8/13/2021 8/14/2021 8/15/2021 8/16/2021 8/17/2021 8/18/2021 8/19/2021 8/20/2021 8/21/2021 8/22/2021 8/24/2021 8/25/2021 8/27/2021 8/28/2021 8/30/2021 8/31/2021 487 359 397 562 602 434 227 382 280 420 388 230 256 314 477 News Opinion Profile Opinion Feature Analysis Opinion News Feature Feature Opinion Opinion News Profile Feature Opinion News News Analysis Feature Opinion News Feature Analysis Profile Professional Professional Professional College Professional Professional Professional Amateur Professional Professional Professional Professional Professional Professional College College Amateur College High School Professional Professional High School Professional College College $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,310 1,218 898 993 1,405 1,505 1,085 568 955 700 1,050 970 575 640 785 1,193 1 23 B E F G H Publication Date D Number of Words Article Title Author Sports Level Ad Amt + + + 1 5 12 19 27 31 32 Article Type Analysis Total Feature Total News Total Opinion Total Profile Total Grand Total $ 2,600 $ 7,045 $ 4,348 $ 6,595 $ 3,223 $ 23,810 + + - 33 34 35 36 37 38 39 40 41 42 43 44 Documentation August Articles Current Articles Proposed Articles August Advertising

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

5. Understand how cultural values influence conflict behavior.

Answered: 1 week ago

Question

e. What do you know about your ethnic background?

Answered: 1 week ago