Microsoft Excel 2010 Expert — Question 16

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2010. 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.

Answer options

• A. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.
• 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.
• D. Select the Macro enabled checkbox of the PivotTable fields for which you want to create a slicer in the Insert Security dialog box and then click OK.
• E. Click anywhere in the PivotTable report for which you want to create a slicer.

Correct answer: A, B, C, E

Explanation

The correct steps to create a slicer and share it with other PivotTables include selecting the appropriate fields in the Insert Slicers dialog box (A), using the Insert Slicer option in the Options tab (B), and clicking on the relevant items while holding CTRL to apply filters (C). Clicking anywhere in the PivotTable report (E) is essential to initiate the slicer creation process. Option D is incorrect as it refers to a non-existent setting related to slicers.