Question: Hello, Can you help me with this question please? Thank you! Problem 3: Use data given sheet Problem 3 SpareBucs Company is a company that
Hello, Can you help me with this question please?
Thank you!
- Problem 3: Use data given sheet "Problem 3" 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.
In which month did SpareBucs generate the highest revenue?


Wrap Text . General Merge & Center . W Auto Sur LA Conditional Format Formatting as Table Cell Styles Insert Fill Delete ] Format nt to continue working where you left off? Clear lantity Unit Price Total Sales 300 4.00 600 8 $ 1,200.00 $ 1,800.00 4.00 Questions 300 $ 1,200.00 600 2.00 $ 1,200.00 a. In which month did SpareBucs generate the highest revenue? 8 888 8 8 8 3.00 $ 2,400.00 b. Which US Region purchased the highest amount of "Coffee" products? 4.00 $ 3,600.00 c. Which product generated the highest revenue in April 20187 5.00 $ 2,000.00 8 8 8 8 $ 2,500.00 $ 1,500.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.00Calibri (Body) A Copy . Wrap Text . General iste Format H Merge & Center 35 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? X Customer Customer Product Customer ID City State US Region Product Category Quantity Unit Price Total Sales 23 Nashville Southeast Breakfast Blend Coffee 4.00 $ 1,200.00 44 Seattle West Vanilla Spices 3.00 $ 1,800.00 Questions 14 Knoxville Southeast Darjeeling Tea 4.00 $ 1,200.00 a. In which month did 15 Atlanta Southeast Mustard Spices 600 $ 2.00 $ 1,200.00 b. Which US Region 44 Seattle WA West Cinnamon Spices 800 $ 3.00 $ 2,400.00 c. Which product gen 23 Nashville Southeast Decaf Coffee 900 S 4.00 $ 3,600.00 18 Denver West Earl Grey Tea 400 $ 5.00 $ 2,000.00 19 Boulder West Green Tea Tea 100 $ 6.00 20 Miami Southeast French Roast Coffee 500 $ 5.00 $ 2,500.00 16 Chicago Midwest Hazelnut Coffee 500 $ 3.00 $ 1,500.00 50 Peoria Midwest Curry Spices 200 $ 4.00 800.00 3 Portland ME Northeast Ginger Spices 2.00 $ 200.00 2 Minneapolis MN Midwest Oolong Tea 800 $ 3.00 $ 2,400.00 11 Portsmouth NH Northeast Vanilla Spices 400 $ 3.00 $ 1,200.00 44 Seattle WA West Mustard Spices 200 $ 2.00 $ 400 00 16 Chicago Midwest Vanilla Coffee 4.00 $ 1,600.00 49 Los Angeles CA West Decaf Coffee 4.00 $ 2,400.00 22 Cleveland OH Midwest Green Tea Tea $ 6.00 $ 4,200.00 11 Portsmouth NH Northeast Oregano Spices 1000 5.00 $ 5,000.00 45 Des Moines IA Midwest Curry Spices 300 1.00 300.00
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
