Critical Thinking Questions Case 6-2
Your supervisor, the accounting manager, asks you to insert the current month's sales estimates by product, which is located in an Excel worksheet, into a sales report you are creating in Publisher to send to each manager electronically.
Which of the following integration methods should you use if each sales manager has access to the source workbook, has permission to change its contents, and is asked to update the source workbook with their latest estimates using the worksheet object in the sales report?
A) copy and paste
B) embedding
C) linking
D) attaching

Question

Quizplus · Accepted Answer

Linking is the correct method because it allows the sales report to automatically update with the latest estimates when the source workbook is updated by the sales managers. This ensures that the sales report always reflects the most current data without needing to manually update the report each time the source workbook is changed.