Question

Create a drill-down of the Volkswagen onto a new worksheet and rename the worksheet Volkswagens. Further modify then PivotTable on the PivotAnalysis worksheet. • Insert a Year slicer and position it so that its top-left corner in the cell D2. • Insert a Vehicle Style slicer and position it to that its top-left corner in cell G2. • Use the Year slicer to only show vehicles that are 2010 and newer.

Answer 1

To create the drill-down of Volkswagen and modify the PivotTable, follow these steps: (1) Drill down the Volkswagen data and create a new worksheet, (2) Rename the worksheet as Volkswagens, (3) Modify the PivotTable on the PivotAnalysis worksheet by inserting Year and Vehicle Style slicers, and (4) Use the Year slicer to filter vehicles for 2010 and newer.

Step-by-step explanation:

To create a drill-down of the Volkswagen onto a new worksheet and rename the worksheet Volkswagens, follow these steps:

1. Right-click on the Volkswagen data in the PivotTable and select 'Drill Down'.
2. Click on the 'New Worksheet' option that appears.
3. To rename the new worksheet, right-click on its tab and select 'Rename'. Type 'Volkswagens' as the new name.

To further modify the PivotTable on the PivotAnalysis worksheet:

• To insert a Year slicer, go to the 'PivotTable Tools' tab and click on 'Insert Slicer'. Choose the 'Year' field and position it in cell D2.
• To insert a Vehicle Style slicer, go to the 'PivotTable Tools' tab and click on 'Insert Slicer' again. Choose the 'Vehicle Style' field and position it in cell G2.
• Use the Year slicer to filter the vehicles. Click on the 'Year' slicer and select '2010' and newer from the options.