Question Completion Status: SpareBucs Company is a company that sells coffee, tea and spices in different cities across the United States. The excel provides the sales data for the first 4 months of 2018. Use pivot tables to answer the questions. Question: In which month did SpareBucs generate the highest revenue? April January February O March QUESTION 9 Which US Region purchased the highest amount of "Coffee" products? Southeast O West Northeast Midwest QUESTION 10 Which product generated the highest revenue in April 2018? Save Al Answers Click Save and Submit to save and submit. Click Save All Answers to save all answers. Excel Classwo.. Excel Homewo is O FinalExam_V2.xdsx LB Paste BIU A.A $ % ) 488 y Cell Styles L7 X A C B D - H J K 7 Mar Customer Customer 1 Sales Month Customer ID City State 2 Jan 23 Nashville TN 3 Feb 44 Seattle WA 4 Mar 14 Knoxville TN 5 Apr 15 Atlanta GA 6 Feb 44 Seattle WA 23 Nashville TN 8 Feb 18 Denver 9 Mar 19 Boulder 10 Feb 20 Miami FL 11 Mar 16 Chicago IL 12 Apr 50 Peoria 13 Mar 3 Portland ME 14 Feb 2 Minneapolis MN 15 Jan 1 Posmouth NH 16 Apr 44 Seattle WA 17 Mar 16 Chicago IL 18 Jan 49 Los Angeles CA 19 Feb 22 develand OH 20 Mar 11 Permouth NH 21 Feb 45 Des Moines IA 22 23 E F G Product US Region Product Category Southeast Breakfast Blend Coffee West Vanilla Spices Southeast Darjeeling Tea Southeast Mustard Spices West Cinnamon Spices Southeast Decaf Coffee West Earl Grey Tea West Green Tea Tea Southeast French Roast Coffee Midwest Hazelnut Coffee Midwest Curry Spices Northeast Ginger Spices Midwest Oolong Tea Northeast Vanilla Spices West Mustard Spices Midwest Vanilla Coffee West Decaf Coffee Midwest Green Tea Tea Northeast Oregano Spices Midwest Curry Spices Quantity Unit Price Total Sales 300 $ 4.00 $1,200.00 600 $ 3.00 $ 1,800.00 300 $ 4.00 $ 1,200.00 600 $ 2.00 $1,200.00 800 $ 3.00 $2,400.00 900 $ 4.00 $3,600.00 400 $ 5.00 $2,000.00 100 $ 6.00 $ 600.00 500 $ 5.00 $ 2,500.00 500 $ 3.00 $1,500.00 200 $ 4.00 $ 800.00 100 $ 2.00 $ 200.00 800 $ 3.00-$2,400.00 400 $ 3.00 $ 1.200.00 200 $ 2.00 $ 400.00 400 $ 4.00 $ 1.600.00 600 $ 4.00 $2,400.00 700 $ 6.00 $4,200.00 1000 $ 5.00 $5,000.00 300 $ 1.00 $ 300.00 Problem 1 Problem 2 Problem 3 + Question Completion Status: SpareBucs Company is a company that sells coffee, tea and spices in different cities across the United States. The excel provides the sales data for the first 4 months of 2018. Use pivot tables to answer the questions. Question: In which month did SpareBucs generate the highest revenue? April January February O March QUESTION 9 Which US Region purchased the highest amount of "Coffee" products? Southeast O West Northeast Midwest QUESTION 10 Which product generated the highest revenue in April 2018? Save Al Answers Click Save and Submit to save and submit. Click Save All Answers to save all answers. Excel Classwo.. Excel Homewo is O FinalExam_V2.xdsx LB Paste BIU A.A $ % ) 488 y Cell Styles L7 X A C B D - H J K 7 Mar Customer Customer 1 Sales Month Customer ID City State 2 Jan 23 Nashville TN 3 Feb 44 Seattle WA 4 Mar 14 Knoxville TN 5 Apr 15 Atlanta GA 6 Feb 44 Seattle WA 23 Nashville TN 8 Feb 18 Denver 9 Mar 19 Boulder 10 Feb 20 Miami FL 11 Mar 16 Chicago IL 12 Apr 50 Peoria 13 Mar 3 Portland ME 14 Feb 2 Minneapolis MN 15 Jan 1 Posmouth NH 16 Apr 44 Seattle WA 17 Mar 16 Chicago IL 18 Jan 49 Los Angeles CA 19 Feb 22 develand OH 20 Mar 11 Permouth NH 21 Feb 45 Des Moines IA 22 23 E F G Product US Region Product Category Southeast Breakfast Blend Coffee West Vanilla Spices Southeast Darjeeling Tea Southeast Mustard Spices West Cinnamon Spices Southeast Decaf Coffee West Earl Grey Tea West Green Tea Tea Southeast French Roast Coffee Midwest Hazelnut Coffee Midwest Curry Spices Northeast Ginger Spices Midwest Oolong Tea Northeast Vanilla Spices West Mustard Spices Midwest Vanilla Coffee West Decaf Coffee Midwest Green Tea Tea Northeast Oregano Spices Midwest Curry Spices Quantity Unit Price Total Sales 300 $ 4.00 $1,200.00 600 $ 3.00 $ 1,800.00 300 $ 4.00 $ 1,200.00 600 $ 2.00 $1,200.00 800 $ 3.00 $2,400.00 900 $ 4.00 $3,600.00 400 $ 5.00 $2,000.00 100 $ 6.00 $ 600.00 500 $ 5.00 $ 2,500.00 500 $ 3.00 $1,500.00 200 $ 4.00 $ 800.00 100 $ 2.00 $ 200.00 800 $ 3.00-$2,400.00 400 $ 3.00 $ 1.200.00 200 $ 2.00 $ 400.00 400 $ 4.00 $ 1.600.00 600 $ 4.00 $2,400.00 700 $ 6.00 $4,200.00 1000 $ 5.00 $5,000.00 300 $ 1.00 $ 300.00 Problem 1 Problem 2 Problem 3 +