Microsoft
77-427 · Question #44
You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You have a number of PivotTables in a single report. You want to apply the same…
The correct answer is A. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you B. Click Insert Slicer in the Sort & Filter group on the Options tab. C. Hold down CTRL, and then click the items on which you want to filter. E. Click anywhere in the PivotTable report for which you want to create a slicer. See the full explanation below for the reasoning.
Question
You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You have a number of PivotTables in a single report. You want to apply the same filter to all of those PivotTables. For this purpose, you are required to create a slicer in one PivotTable and share it with other PivotTables. Which of the following steps will you take to accomplish the task? Each correct answer represents a part of the solution. Choose all that apply.
Options
- AIn the Insert Slicers dialog box, select the check box of the PivotTable fields for which you
- BClick Insert Slicer in the Sort & Filter group on the Options tab.
- CHold down CTRL, and then click the items on which you want to filter.
- DSelect the Macro enabled checkbox of the PivotTable fields for which you want to create a
- EClick anywhere in the PivotTable report for which you want to create a slicer.
How the community answered
(29 responses)- A69% (20)
- D31% (9)
Community Discussion
No community discussion yet for this question.