Question: Please help me number 3,4,5,6 with the formula. 2. Create a PivotTable using the data in the Sales worksheet. Place the PivotTable in a new

Please help me number 3,4,5,6 with the formula.

Please help me number 3,4,5,6 with the formula.
2. Create a PivotTable using the data in the Sales worksheet. Place the PivotTable in a new worksheet named PT1. The PivotTable should help you analyze the sales by department. Change the number format of the sales data to Currency with two decimal places, and sort the sales data so that the department with the highest sales amount appears first. 3. Copy the PT1 worksheet to a new worksheet named PT2. Notice that you are creating a copy of the entire PT1 worksheet, not just the actual PivotTable! Rearrange the fields in the PivotTable to analyze department sales by quarter. Use conditional formatting to apply a yellow fill color to the cells that represent the highest quarterly sales amount in each of the four quarters. 4. Copy the PT2 worksheet to a new worksheet named PT3. Clear the conditional formatting. Add the Manager field to the PivotTable to analyze each department's quarterly sales performance by manager. Type the name of the manager who had the highest sales in the Flooring Department during the third quarter in cell A1. 5 . Copy the PT3 worksheet to a new worksheet named PT4. Rearrange the fields in the PivotTable to analyze each manager's quarterly sales performance by department. Type the name of the department that represents the highest overall sales amount for Bill Smoot in cell A1. 6. Copy the PT4 worksheet to a new worksheet named PT5. Delete the text in cell A1. Remove the Date and Department fields from the PivotTable. Add a slicer for the Department field and a timeline for the Date field. Use the slicer and the timeline to filter the PivotTable to show the total sales amount for each manager for the Kitchen and Bath and Plumbing Departments for April 2015 through October 2015

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!