Which path describes inserting a slicer for the Category field?

Which path describes inserting a slicer for the Category field?

• A. Design > Tools > Insert Slicer > Category checkbox
• B. Insert > Slicer > Category
• C. Data > Slicer > Category
• D. Home > Slicer

Answer: (A)

Slicers provide a visual way to filter a PivotTable by a field. The place to add a slicer for a PivotTable field is within the PivotTable Tools on the ribbon, specifically on the Design tab. From there, you use the Tools group to choose Insert Slicer and then select the Category field. This creates a slicer tied to Category, letting you filter the PivotTable by clicking the category items. Other ribbon paths don’t reflect the standard location for adding a PivotTable slicer in most versions, so they wouldn’t place the slicer with the Category field in the same integrated way.

Slicers provide a visual way to filter a PivotTable by a field. The place to add a slicer for a PivotTable field is within the PivotTable Tools on the ribbon, specifically on the Design tab. From there, you use the Tools group to choose Insert Slicer and then select the Category field. This creates a slicer tied to Category, letting you filter the PivotTable by clicking the category items.

Other ribbon paths don’t reflect the standard location for adding a PivotTable slicer in most versions, so they wouldn’t place the slicer with the Category field in the same integrated way.