(LO 2-7) Summarize sales by month, by sales region (regions 1-4), and by both month and region.

Required:

1. Download the file “Daily Company Sales.xlsx” in Excel.

2. Use a PivotTable to sum sales by month.

a. Capture a screenshot of sales by month, paste it into a Word document named

"Problem 2-5 SS.doc", and label it Submission 1.

b. What are the January monthly sales?

c. What are the February monthly sales?

3. Use a PivotTable to sum sales by region.

a. Capture a screenshot of sales by region, paste it into your "Problem 2-5 SS.doc"

Word document, and label it Submission 2.

b. What are the total sales for region 3?

c. What are the total sales for region 1?

4. Use a PivotTable to sum sales by both month and region. (Hint: In the PivotTable, put month in the rows and region in the columns.)

a. Capture a screenshot of sales by month and region, paste it into your "Problem 2-5 SS.doc" Word document, and label it Submission 3.

b. What are the December sales for region 2?

c. What are the April sales for region 3?

5. In Connect, upload your Problem 2-5 SS.doc if assigned.