Critical Thinking Questions Case 5-2 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

Option B suggests creating a new dependent workbook containing a consolidation worksheet and then creating 3-D linking formulas to the three source workbooks to summarize the data in the consolidation worksheet. This is the most efficient way to summarize the data from the three workbooks without spending hours to do it manually. Option A involves copying and pasting data manually, which can be time-consuming, and option C suggests exporting the data to a database, which may not be necessary for a simple data summarization task. Option D is not a feasible solution as it will not accomplish the task of summarizing the data efficiently.

Critical Thinking Questions Case 5-2 Judy, an Administrative Assistant to the Sales