Question 1

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

Accepted Answer

A)  copy and paste 
B)  embedding 
C)  linking 
D)  insert

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

The answer of  Figure 5 Using the accompanying figure,...

Question 4

Match between columns
                        Premises: Object Linking and Embedding
An option in the Links dialog box
The integration method that places Word text in a Publisher text box or Access data in a Publisher table
An option in the Insert Object dialog box
An option in the Paste Special dialog box

Accepted Answer

The Answer of Create from File and OLE and Link is...

Question 5

The Paste Special command is located on the ____________________ menu.

Accepted Answer

The answer of The Paste Special command is located on...

Question 6

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

Accepted Answer

A)  Linking 
B)  Pasting 
C)  Embedding 
D)  Saving

Question 7

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

Accepted Answer

A)  Excel 
B)  Word 
C)  Publisher 
D)  Access

Question 8

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

Accepted Answer

A)  destination publication 
B)  source file 
C)  linked object 
D)  VBA window

Question 9

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

Accepted Answer

A)  worksheet 
B)  workbook 
C)  document 
D)  publication

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A)  text box 
B)  table 
C)  object 
D)  graphic

Question 12

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

Accepted Answer

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 13

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

Accepted Answer

The answer of Changes made to a Publisher table created...

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

A workbook consists of cells organized into columns and rows.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The answer of You can edit a(n) ____________________ object using...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)  File 
B)  Edit 
C)  Tools 
D)  Locate

Question 20

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.

Accepted Answer

A)  Paste 
B)  Paste Now 
C)  Paste Link 
D)  Paste Embed

Exam 8: Integration Feature - Object Linking and Embedding

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

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

Identify the letter of the choice that best matches the phrase or definition.

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

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.