Answered step by step
Verified Expert Solution
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!
The out should be the same as it the table below
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started