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

question 22

Multiple Choice

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 says the attendance clerk will change the data in the source workbook each week and she wants an efficient way to make certain that the attendance summary she sends to her supervisor always contains the most current data and totals? ____

• A) You are sorry, but there is no way to ensure that the publication always contains the most current data and totals
• B) Replace the table with a linked object using the Object command on the Insert menu
• C) Delete the table and attach a copy of the source worksheet to the publication
• D) Replace the table with an embedded object using the Object command on the Insert menu