Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please include screenshots in your answer and step by step instructions of what to click. Exp 2 2 _ Excel _ Ch 0 5 _
Please include screenshots in your answer and step by step instructions of what to click. ExpExcelChCumulativeMerchandise
Project Description:
You manage the souvenir shop for a touring Broadway production. The shop sells apparel, souvenirs, and media items. You created datasets to analyze sales in the different categories. One sheet contains apparel sales for the first two weeks of the month. You will insert subtotal rows in this worksheet. The second sheet contains product information for the first quarter of the year. You will create a PivotTable, insert a timeline, and create a PivotChart using this data. You will create a second PivotTable so that you can filter data and calculate product prices if you run a sale. Finally, the last sheet contains two tables containing employee data. You will create a relationship and then create a PivotTable using that data.
Steps to Perform:
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