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 to allow each sales manager to change the estimates for his or her department in a what-if analysis using the worksheet object in the sales report?
A) copy and paste
B) embedding
C) linking
D) attaching

Question

Quizplus · Accepted Answer

Embedding the Excel worksheet into the Publisher document allows each manager to interact with and change the estimates directly within the sales report, facilitating what-if analysis without altering the original Excel file.