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.

The correct answer is A. In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook 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. 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…

Manage and share workbooks

Question

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

AIn the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook
BClick Compare and Merge Workbooks on Quick Access Toolbar.
COpen the copy of the shared workbook to merge the changes.
DSave the workbook if prompted.
EAdd Compare and Merge Workbooks.
FClick Compare and Merge Workbooks on Macro Enabled Access Toolbar.

How the community answered

(25 responses)

A
84% (21)
F
16% (4)

Explanation

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.

Topics

#shared workbooks#merge workbooks#Compare and Merge Workbooks#Quick Access Toolbar

Community Discussion

No community discussion yet for this question.

Full 77-427 Practice