Which of the following is required before workbooks can be compared and merged?

A. The original shared workbook must have the change history active.
B. Each copy of the workbook must have been made from the original shared workbook.
C. Each copy of the workbook must have a different file name and cannot have any passwords.
D. All of the above.

Answer :

Final answer:

The original shared workbook must have the change history active, each copy of the workbook must have been made from the original shared workbook, and each copy of the workbook must have a different file name and cannot have any passwords.

Explanation:

The correct answer is d. All of the above. Before workbooks can be compared and merged, the original shared workbook must have the change history active, each copy of the workbook must have been made from the original shared workbook, and each copy of the workbook must have a different file name and cannot have any passwords.