Answered step by step
Verified Expert Solution
Link Copied!

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 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.3'' and the width to 1.2''.
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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

AutoCAD Database Connectivity

Authors: Scott McFarlane

1st Edition

0766816400, 978-0766816404

More Books

Students also viewed these Databases questions