(LO 2-7) Summarize monthly sales and compute the % Change from one month to the next (as...
Question:
(LO 2-7) Summarize monthly sales and compute the % Change from one month to the next (as shown in the chapter).
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-4 SS.doc", and label it Submission 1.
b. What is the July monthly sales?
c. What is the November monthly sales?
3. Modify the Value Field Settings (as shown in the chapter) and calculate the % Change from one month as compared to the previous month.
a. Capture a screenshot of the percentage change from the previous month, paste it into your Word document named "Problem 2-4 SS.doc" from requirement 2, and label it Submission 2.
b. What is the percentage change in monthly sales from May to June (round to 2 decimal points)?
c. What is the percentage change in monthly sales from November to December
(round to 2 decimal points)?
4. In Connect, upload your Problem 2-4 SS.doc if assigned.
Step by Step Answer:
Introduction To Data Analytics For Accounting
ISBN: 9781266358234
2nd Edition
Authors: Vernon Richardson, Katie Terrell And Ryan Teeter