Judy, an administrative assistant to the sales manager, sends you an e-mail requesting some help on a current project. The sales manager has created three separate workbooks in which she stores sales data. Judy needs to create a new workbook with worksheets that summarize the data from the three workbooks; she asks if there is any way to summarize the data in the three workbooks without spending hours to do it manually.
-You tell Judy that ____.
A) she should copy the data from each worksheet in the three workbooks and paste the data into a single worksheet in a new workbook; then create simple formulas to add all the data
B) she can create a new dependent workbook containing a consolidation worksheet; then create 3-D linking formulas to the three source workbooks to summarize the data in the consolidation worksheet
C) she should try to export the data in the three workbooks into a database program; then create a summary report using the database report tool
D) unfortunately,she will have to manually prepare the summary from data in the three workbooks

Question

Quizplus · Accepted Answer

Creating a new dependent workbook with a consolidation worksheet and using 3-D linking formulas allows Judy to efficiently summarize data from multiple workbooks without manual copying and pasting.

Judy, an Administrative Assistant to the Sales Manager, Sends You