Microsoft
77-427 · Question #41
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…
The correct answer is A. Clear the check box of any PivotTable fields for which you want to disconnect a slicer. C. Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort. See the full explanation below for the reasoning.
Question
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
- AClear the check box of any PivotTable fields for which you want to disconnect a slicer.
- BRight-click the slicer, and then click Remove <Name of slicer>.
- CClick the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort
- DClick the slicer, and then press Delete.
How the community answered
(28 responses)- A71% (20)
- B18% (5)
- D11% (3)
Community Discussion
No community discussion yet for this question.