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.
Which of the following steps will you take to merge copies of a shared workbook? Each correct
answer represents a part of the solution. Choose all that apply.
Take the following steps to merge copies of a shared workbook:
1.Add Compare and Merge Workbooks.
2.Open the copy of the shared workbook to merge the changes.
3.Click Compare and Merge Workbooks on Quick Access Toolbar.
4.Save the workbook if prompted.
5.In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook
containing changes to be merged, and then click OK.