Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hi fast please thanks 35 05 92 12 04 47 19 -14 15 14 03 28 44 191 84) 44 93 58 -783 481 47

hi fast please thanks
image text in transcribed
image text in transcribed
35 05 92 12 04 47 19 -14 15 14 03 28 44 191 84) 44 93 58 -783 481 47 641 821 30 35 57 90 30 15] 27 39] 891 366 13 634 57 20 H N Answers the questions in cells H13-H17 below. Use Group when items are listed (the conversion table is listed in cells H25 136, you will need to use VLOOKUP to fill out Group) Each question is worth 3 point. Note, no range names have been created for you. if you decide to answer these questions using a pivot tables, please create a new pivot table for each answer your answer needs to be easily findable on the pivot table to receive credit 10 points total Part Table for Group Product apples Den and Jerry's Breyers Cheerios cherries chocolate Edies grapes low fat plums Raisin Bran skim Special K whole Average Revenue for all ice cream sales Total number of records for sales of milk Total Units of cereal sold in any October Group fruit ice cream ice cream Total Revenue of Fruit sold in any February and of ice cream sold in the East Average Revenue for non-fruit items sold in either the East or West sold between April and August "difficult problem, still worth only 3 points cereal fruit milk O ice cream fruit milk fruit cereal milk cereal milk P Points Total Points Q 0 15 L11 A B 1 Year Month 2 2007 August 2006 March 3 4 2008 January 5 2006 March 6 2007 January 2009 September east north south west east north west south west east south west 16 2006 June west 17 2006 March south 18 2006 September east 19 2009 October east 7 8 2009 March 9 2009 June 10 2007 July 11 2006 May 12 2006 June 13 2006 October 14 2007 June 15 2006 May 20 2009 November least 21 2009 May 22 2008 August 23 2006 June 24 2007 April 25 2006 February 26 2008 November 27 2006 July 28 2006 July 29 2009 August 30 2008 December 31 2008 August 32 2007 October 11 2007 January 34 2008 June 35 2006 July 2006 lanuary 371 2009 July 38 2009 September 2007 October 40 2006 March C Store south south *** Esc Enl south south west south west east north west south south west north north north south west east west north **** Product low fat Edies skim Edies Edies plums low fat D apples cherries Special K Edies Raisin Bran grapes skim Raisin Bran Raisin Bran Edies chocolate Brevers Breyers low fat Edies Edies plums Special K Edies Breyers Brevers plums plums grapes Edes Cheerlos apples low fat Exe02- NFL Data Select destination and press ENTER or choose Paste Cheerios Raisin Bran Raisin Bran Raisin Bran fx E Group F Revenue $ 3,187 80 $ 3,412 48 $ 1,808.48 $ 2,260.00 $ 2,076.87 $ 1,707.09 $ 2,181.76 $ 1,894.20 $ 1,856.40 $ 1,553.63 $ 2,064.48 $1,809.64 $ 2,196.41 $ 1,932.84 $ 1,987.68 $ 2,217.12 $ 2,189.88 $ 1,895.04 $ 3,274.94 $ 3,281.76 $ 1,247 16 $ 1,513.92 $ 2,716.56 $ 2,408.70 $ 2,594 55 $ 1,542 89 $2,456 90 $ 2,664 50 $ 2,901 40 $ 2,006.52 $ 1,71304 $ 2,319.33 $ 1,544.51 $ 2.866.46 $ 1,395.36 735 557 790 730 815 7271 644) 739 866 513 G Units 805 878 848 547 664 8821 9305 992 712 904 647 739 974 615 767 984 744 693 658) 534 587 770 536 and 714 703 528 644 $ 1.244.22 $ 1.59027 $ 1817.20 $ 1,972 48 Exe03 Monet Frames H Tabl Prod apple Ben a Breyes Cheerm cherries chocola Edies grapes low fat plums Raisin Br skim Special K whole Exe0 35 05 92 12 04 47 19 -14 15 14 03 28 44 191 84) 44 93 58 -783 481 47 641 821 30 35 57 90 30 15] 27 39] 891 366 13 634 57 20 H N Answers the questions in cells H13-H17 below. Use Group when items are listed (the conversion table is listed in cells H25 136, you will need to use VLOOKUP to fill out Group) Each question is worth 3 point. Note, no range names have been created for you. if you decide to answer these questions using a pivot tables, please create a new pivot table for each answer your answer needs to be easily findable on the pivot table to receive credit 10 points total Part Table for Group Product apples Den and Jerry's Breyers Cheerios cherries chocolate Edies grapes low fat plums Raisin Bran skim Special K whole Average Revenue for all ice cream sales Total number of records for sales of milk Total Units of cereal sold in any October Group fruit ice cream ice cream Total Revenue of Fruit sold in any February and of ice cream sold in the East Average Revenue for non-fruit items sold in either the East or West sold between April and August "difficult problem, still worth only 3 points cereal fruit milk O ice cream fruit milk fruit cereal milk cereal milk P Points Total Points Q 0 15 L11 A B 1 Year Month 2 2007 August 2006 March 3 4 2008 January 5 2006 March 6 2007 January 2009 September east north south west east north west south west east south west 16 2006 June west 17 2006 March south 18 2006 September east 19 2009 October east 7 8 2009 March 9 2009 June 10 2007 July 11 2006 May 12 2006 June 13 2006 October 14 2007 June 15 2006 May 20 2009 November least 21 2009 May 22 2008 August 23 2006 June 24 2007 April 25 2006 February 26 2008 November 27 2006 July 28 2006 July 29 2009 August 30 2008 December 31 2008 August 32 2007 October 11 2007 January 34 2008 June 35 2006 July 2006 lanuary 371 2009 July 38 2009 September 2007 October 40 2006 March C Store south south *** Esc Enl south south west south west east north west south south west north north north south west east west north **** Product low fat Edies skim Edies Edies plums low fat D apples cherries Special K Edies Raisin Bran grapes skim Raisin Bran Raisin Bran Edies chocolate Brevers Breyers low fat Edies Edies plums Special K Edies Breyers Brevers plums plums grapes Edes Cheerlos apples low fat Exe02- NFL Data Select destination and press ENTER or choose Paste Cheerios Raisin Bran Raisin Bran Raisin Bran fx E Group F Revenue $ 3,187 80 $ 3,412 48 $ 1,808.48 $ 2,260.00 $ 2,076.87 $ 1,707.09 $ 2,181.76 $ 1,894.20 $ 1,856.40 $ 1,553.63 $ 2,064.48 $1,809.64 $ 2,196.41 $ 1,932.84 $ 1,987.68 $ 2,217.12 $ 2,189.88 $ 1,895.04 $ 3,274.94 $ 3,281.76 $ 1,247 16 $ 1,513.92 $ 2,716.56 $ 2,408.70 $ 2,594 55 $ 1,542 89 $2,456 90 $ 2,664 50 $ 2,901 40 $ 2,006.52 $ 1,71304 $ 2,319.33 $ 1,544.51 $ 2.866.46 $ 1,395.36 735 557 790 730 815 7271 644) 739 866 513 G Units 805 878 848 547 664 8821 9305 992 712 904 647 739 974 615 767 984 744 693 658) 534 587 770 536 and 714 703 528 644 $ 1.244.22 $ 1.59027 $ 1817.20 $ 1,972 48 Exe03 Monet Frames H Tabl Prod apple Ben a Breyes Cheerm cherries chocola Edies grapes low fat plums Raisin Br skim Special K whole Exe0

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

Recommended Textbook for

Handbook Of Consumer Finance Research

Authors: Jing Jian Xiao

2nd Edition

3319288857, 978-3319288857

More Books

Students also viewed these Finance questions