Back to lesson
1. If you wanted to add the following slicer to your PivotTable, how would you do it?
Select the Pivot > PivotTable Tools > Analyze (Options in Excel 2010) > Insert Slicer > Click the checkbox next to Category.
Right click the PivotTable > Add Slicer > Click the checkbox next to Category.
Select the Pivot > PivotTable Tools > Design > Insert Slicer > Click the checkbox next to Category.
2. How do you select multiple items as shown in the following slicer?
Click the clear filter icon at the top right, then left click each item you’d like to select.
Select the first item, hold down the CTRL key, and select each subsequent item.
Select the first item, hold down the SHIFT key, and select each subsequent item.
3. Why are slicers better than report filters?
They are easier to use with PivotTables than report filters.
They invite user interaction with your PivotTable.
They filter PivotTables in more efficient ways than a report filter.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement