Please include screenshots in your answer and step by step instructions of what to click. Exp$22\_$Excel$\_$Ch$05\_$Cumulative$\_$Merchandise $1\mathrm{.}1$

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: