Microsoft Excel 2010 Expert — Question 4

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are required to use a slicer. Which of the following are the ways that you can use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

Answer options

• A. Create a copy of a slicer connected with the PivotTable.
• B. Create a slicer connected with the PivotTable.
• C. Create a slicer by disabling Macros associated with the PivotTable.
• D. Use an existing slicer connected with another PivotTable.

Correct answer: A, B, D

Explanation

Options A, B, and D are valid because they all involve using slicers that are appropriately connected to the PivotTable, allowing for efficient data filtering. Option C is incorrect because disabling Macros does not facilitate the creation of a slicer and may hinder functionality.