Critical Thinking Questions Case SF2-2 A co-worker needs your help! She copied data including totals from an Excel worksheet and pasted the data in a table in an attendance summary publication using the Copy and Paste commands. She just learned that the some of the attendance data has changed. You discuss the problem of changing data with your co-worker. What should you tell your co-worker if she wants to change the data only in the publication and she wants the totals to automatically recalculate? ____
A) Delete the table and paste the data as an embedded object using the Paste Special command
B) Use a calculator to retotal the data and type the new totals in the total cells in the table
C) Delete the table and paste the data into a text box
D) Open the source workbook, change the data, and save the workbook

Question

Quizplus · Accepted Answer

Using the Paste Special command to paste the data as an embedded object allows the data to be linked to the original Excel worksheet. This way, any changes made to the data in the publication will automatically update the totals, as they are recalculated based on the embedded Excel functionality.

Critical Thinking Questions Case SF2-2 a Co-Worker Needs Your Help!