Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Careers in Practice 2 ( Skills Review ) Beach Front Gift Shop ( Comprehensive Review ) Starter File: Continue with your Chapter 5 CiP Exercise
Careers in Practice Skills Review
Beach Front Gift Shop Comprehensive Review
Starter File: Continue with your Chapter CiP Exercise file.
This exercise continues with where you left off form Careers in Practice Exercise Make sure you have corrected the Exercise file before continuing on
Based on the data in the Aug Data worksheet, create a PivotTable in a new worksheet that shows the total sales receipts by Day. Format the data area with currency format. Rename the worksheet with the PivotTable as PivotTable by Day.
In the PivotTable by Day worksheet, insert a Clustered Column PivotChart based on the PivotTable you created. Move the PivotChart to row to the right of the PivotTable. Remove the legend, and then change the PivotChart title to Receipts by Day of the Week.
Based on the data in the Aug Data worksheet, create a PivotTable in a new worksheet that shows cash receipts by Trn Date. Add the Department field to the Columns area. Format the Amount field with Accounting format with two decimal places. Rename the worksheet PivotTable by Trn Date.
In the PivotTable by Trn Date worksheet, insert a slicer for the Department field of the PivotTable. Change the slicer height to and the width to
Use the slicer to filter the PivotTable by Trn Date to display only the Hot Drinks and Baked items amounts.
Based on the data in the Aug Data worksheet, insert the Recommended PivotTable Sum of Amount by Week # and Department PivotTable. Rename the worksheet as Recommended PivotTable. The week number is the week number the date falls in for the year.
All of your PivotTables should have titles that describe the data being presented. Your column headers should also be changed to describe data presented. All PivotTable and PivotChart data should be professionally formatted.
Save your file. Insert your name before the file name.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started