Microsoft Excel 2010 Expert — Question 22

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.

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

Correct answer: A, B, C, D, E

Explanation

The correct steps involve selecting the appropriate workbook copies and utilizing the merge function to incorporate changes. Options A, B, C, and D are essential actions in the merging process, while option E is redundant since the Compare and Merge Workbooks feature is already included in option B.