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.
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.
Explanation:
The various ways to use or create slicers to filter PivotTable data in an existing PivotTable are as follows:
1. Create a slicer connected with the PivotTable.
2. Create a copy of a slicer connected with the PivotTable.
3. Use an existing slicer connected with another PivotTable.
Answer option C is incorrect. This is an invalid answer option.