Careers in Practice $2($Skills Review$)$

Beach Front Gift Shop $($Comprehensive Review$)$

Starter File: Continue with your Chapter $5$ CiP Exercise $1$ file.

This exercise continues with where you left off form Careers in Practice Exercise $1.$ Make sure you have corrected the Exercise $1$ 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 $3$ 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 ${1\mathrm{.}3}^{\text{'}\text{'}}$ and the width to ${1\mathrm{.}2}^{\text{'}\text{'}}.$

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.