Microsoft
77-427 · Question #56
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 C. Click the slicer, and then press Delete. D. Right-click the slicer, and then click Remove <Name of slicer>. Take one of the following steps to delete a slicer: 1. Right-click the slicer, and then click Remove <Name of slicer>. 2. Click the slicer, and then press Delete. Answer options B and A are incorrect. These are invalid answer options.
Create Advanced Charts and PivotTables
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 delete the slicer. Which of the following steps can you take to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
Options
- AClick the slicer that you want to delete on the Options tab in the Slicer type group.
- BClick the Macro setting, and then delete the slicer from the Macro-enabled slicers list.
- CClick the slicer, and then press Delete.
- DRight-click the slicer, and then click Remove <Name of slicer>.
How the community answered
(31 responses)- A13% (4)
- B6% (2)
- C81% (25)
Explanation
Take one of the following steps to delete a slicer: 1. Right-click the slicer, and then click Remove <Name of slicer>. 2. Click the slicer, and then press Delete. Answer options B and A are incorrect. These are invalid answer options.
Topics
#PivotTable slicer#delete slicer#filter data#slicer management
Community Discussion
No community discussion yet for this question.