Exam 8: Integration Feature - Object Linking and Embedding

The ____ method is sometimes the better alternative when integrating Publisher objects into other Office applications.

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? ____

Figure 5 Using the accompanying figure, list the steps to open a publication and embed an Excel worksheet object.

The Paste Special command is located on the ____________________ menu.

____ means establishing a connection between a source file and a destination publication so that a representation of the source file appears in the destination file.

When you open a publication containing a linked worksheet object, ____ automatically tries to locate the source file.

Figure 3 As shown in the accompanying figure, all editing of a linked object takes place in the ____.

Figure 1 A(n)____, as shown in the accompanying figure, is an Excel work area that consists of columns and rows.

When you edit an embedded object, you must have the object's source application installed on your computer.

When you copy and then paste Excel worksheet data into a publication, the data is pasted into a Publisher ____.

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? ____

Changes made to a Publisher table created by ____________________ Excel worksheet data are not reflected in the table's source file.

When you use the Object command on the Insert menu to embed or link an object you must indicate the source file by keying the path to the file or browsing for the file.

A workbook consists of cells organized into columns and rows.

You should choose the linking integration method when you want a static object in the destination file.

You can edit a(n) ____________________ object using its source application commands without opening the source application.

You can integrate information between Office applications in three ways: copying and pasting, embedding, and linking.

To change the location of a linked object's source file, click the Link command on the ____ menu.

Figure 4 To create a linked object using the Paste Special command, be certain to click the ____ option button, as shown in the accompanying figure.