Câu 15: 77-888: Excel 2010 Expert

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 otherPivotTables. 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.

1. A. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer. — đáp án hiện tại
2. B. Click Insert Slicer in the Sort & Filter group on the Options tab. — đáp án hiện tại
3. C. Hold down CTRL, and then click the items on which you want to filter. — đáp án hiện tại
4. 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.
5. E. Click anywhere in the PivotTable report for which you want to create a slicer. — đáp án hiện tại