Which feature is commonly used to narrow the data shown in a pivot table?

• A. Sorting
• B. Slicers
• C. Filters
• D. Conditional formatting

Answer: (B)

Slicers let you filter a pivot table in a visual, interactive way. A slicer presents a set of buttons for the values in a field (like regions, products, or dates), and clicking one or more buttons narrows the data shown in the pivot table immediately. This makes it easy to focus on specific segments and even use the same slicer to control multiple pivot tables or charts at once, keeping views synchronized.

This approach is especially handy when you want quick, user-friendly filtering without digging into drop-down menus, and it supports multi-select for comparing several categories side by side.

Sorting rearranges items but doesn’t reduce what’s displayed, while conditional formatting highlights data without filtering it. Regular filters can narrow data, but slicers provide a more intuitive, visual filtering experience and work across multiple pivot tables.