Final answer:
Graphical objects used for filtering data in PivotTables and PivotCharts are called slicers. They allow users to filter and analyze subsets of data through interactive buttons on the worksheet. c) Slicers
Step-by-step explanation:
The graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts are called slicers. Slicers provide a quick and effective way to filter through large sets of data in an interactive manner. When you use a slicer to filter data, only the relevant items remain visible in the PivotTable or PivotChart, making it easier to analyze specific subsets of data. Unlike traditional filters that are applied directly to the PivotTable or PivotChart fields, slicers are displayed as buttons on the worksheet. This makes it easy to see the current filtering state and quickly switch between different views of the data. Slicers are graphical objects in Excel that contain buttons allowing users to filter data in PivotTables and PivotCharts interactively. They provide a visual and user-friendly way to control and navigate data within these dynamic analytical tools. By clicking on specific buttons in the slicer, users can instantly filter and highlight data points in their PivotTables and PivotCharts. Slicers enhance the overall usability of Excel's data analysis features, providing an intuitive means to explore and analyze large datasets dynamically. They serve as a valuable tool for data visualization and exploration in a user-friendly and efficient manner.