Critical Thinking Questions Case SF2-1 Your supervisor, the accounting manager, asks you to insert the current month's sales estimates by product located in an Excel worksheet into a sales report you are creating in Publisher that will be sent 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 are 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 the worksheet object in the sales report to the source workbook would allow the sales managers to update the estimates in the source workbook without altering the sales report. This is the best choice because it ensures accuracy and consistency across all reports, as well as allowing for easy updates in the future. Additionally, copy and paste, embedding, and attaching do not allow for easy updates and could lead to errors if different versions of the data are used.

Critical Thinking Questions Case SF2-1 Your Supervisor, the Accounting Manager