Question No 7
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to 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 using a slicer. After filtering the data, you want to disconnect the slicer. You have clicked anywhere in the PivotTable report. Which of the following steps will you take next to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.
Options
A. Clear the check box of any PivotTable fields for which you want to disconnect a slicer
B. Right-click the slicer, and then click Remove <Name of slicer>.
C. Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort & Filter group.
D. Click the slicer, and then press Delete.
Answer: A,C
No comments:
Post a Comment
Note: only a member of this blog may post a comment.