Microsoft
77-427 · Question #44
77-427 Question #44: Real Exam Question with Answer & Explanation
Sign in or unlock 77-427 to reveal the answer and full explanation for question #44. The question stem and answer options stay visible for context.
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.
Unlock 77-427 to see the answer
You've previewed enough free 77-427 questions. Unlock 77-427 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.