What feature allows you to display only certain data in a pivot table?

• A. Formatting
• B. Slicers
• C. Filters
• D. Sorting

Answer: (C)

Showing only the data you need in a pivot table is done through filtering. Filters let you limit which values appear by selecting specific categories, ranges, or conditions for a field, so the pivot table displays just that subset. For example, you can filter by region to view sales data for a particular region or filter by product category to focus on electronics. You apply a filter to a field, or use a report filter that affects the whole table, and the pivot table updates to show only the chosen data.

Formatting changes how data looks but not which data is included; sorting changes the order of items but not the data that’s shown. Slicers, while providing an easy, visual way to filter, still rely on the same filtering concept to limit the data displayed.