March Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bigdisc65

Selected 77-888 Microsoft Office Specialist Questions Answers

Page: 2 / 2
Question 8

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.

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.

Question 9

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.

Options:

A.

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.

B.

Click Compare and Merge Workbooks on Quick Access Toolbar.

C.

Open the copy of the shared workbook to merge the changes.

D.

Save the workbook if prompted.

E.

Add Compare and Merge Workbooks.

F.

Click Compare and Merge Workbooks on Macro Enabled Access Toolbar.

Page: 2 / 2
Selected 77-888 Microsoft Office Specialist Questions Answers,
Exam Code: 77-888
Exam Name: Microsoft Excel 2010 Expert
Last Update: Apr 14, 2023
Questions: 62
77-888 pdf

77-888 PDF

$31.5  $90
77-888 Engine

77-888 Testing Engine

$36.75  $105
77-888 PDF + Engine

77-888 PDF + Testing Engine

$49  $140