MO-211 practice question 4 of 35

What is a slicer in Excel?

Full set: 355 questions

Domain Insert tables, charts, SmartArt, 3D models, and media

Answer options
A: A function that allows you to carry out complex calculations in Excel
B: A type of chart that displays data as a series of columns or bars
C: A tool that allows you to filter data in a PivotTable or PivotChart Correct answer
D: An add-in that provides additional charting capabilities
Correct Answer:
C. A tool that allows you to filter data in a PivotTable or PivotChart
Explanation

A slicer is a visual filtering tool in Microsoft Excel that enhances the interactivity of data analysis. It provides a set of buttons that enable users to quickly filter data in PivotTables, PivotCharts, and formatted Excel tables. Instead of using traditional drop-down filter lists, slicers allow for a more intuitive, one-click filtering experience. They also visually indicate the current filtering state, making it easy to understand what data is being displayed in the connected report or chart.

Why Incorrect

A. This describes Excel functions, which are formulas used for performing calculations, not interactive filtering components.
B. This describes a Column or Bar chart, a type of data visualization, whereas a slicer is a control for filtering data.
D. Slicers are a native, built-in feature of Excel and do not require a separate add-in to be installed.

References

1. Microsoft Corporation. (n.d.). Use slicers to filter data. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d.

Reference Point: The first paragraph states

"Slicers provide buttons that you can click to filter tables

or PivotTables. In addition to quick filtering

slicers also indicate the current filtering state

which makes it easy to understand what exactly is shown in a filtered PivotTable." This directly supports the correct answer.

2. University of Wisconsin-Madison

Division of Information Technology. (2023). Excel - Using Slicers. UW-Madison KnowledgeBase. KB0021103.

Reference Point: The document's summary states

"Slicers are visual filters. Using a slicer

you can filter your data (or PivotTable) by clicking on the type of data you want." This confirms that a slicer's primary function is to act as a filter.

3. University of California

Berkeley. (n.d.). Excel: Pivot Tables - Slicers. Library Data Lab.

Reference Point: In the "Slicers" section

it is described as: "Slicers are interactive controls that allow you to visualize and filter your data in a PivotTable." This reinforces that slicers are interactive filtering controls for PivotTables.

Scroll to Top