77-427 Free Dumps Study Materials
Question 8: 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.
Correct Answer: A,B,D
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.