Deck 8: Integration Feature - Object Linking and Embedding

Question 1

When you open a publication containing embedded objects, you have the opportunity to update those objects with changes from the source file.

Answer 1

False

Question 2

Embedded objects can be edited; however changes only appear in the source file.

Answer 2

False

Question 3

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

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

Answer 3

C

Question 4

If you want the data in an object to remain unchanged when changes are made to the source file, you should use the ____ integration method.

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

Question 5

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.

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

Question 6

When integrating information between two Office applications, the original file is called the destination file.

Question 7

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

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

Question 8

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

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

Question 9

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

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

Question 10

____ means inserting a source file into a destination publication as an object that can be edited with source application tools within the destination application.

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

Question 11

If you want an object's content to reflect any changes made in the source file, you should use the ____ integration method.

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

Question 12

A workbook consists of cells organized into columns and rows.

Question 13

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

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

Question 14

____ most embedded objects displays the object's source application commands.

A) Clicking
B) Double-clicking
C) Triple-clicking
D) Right-clicking

Question 15

When you edit a linked worksheet object in a publication, your system automatically starts the ____ application, if it is not already running.

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

Question 16

Many worksheets can be stored in an Excel workbook.

Question 17

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

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

Question 18

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

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

Question 19

Figure 2 Opening an embedded object for editing displays the Excel ____ containing commands, as shown in the accompanying figure.

A) Ribbon
B) Standard toolbar
C) menu bar
D) Formatting toolbar

Question 20

____ is a technology that allows you to paste, embed, or link a file or partial file created in one Office application into a different Office application.

A) ABC
B) OLE
C) MIDI
D) HTML

Question 21

The first step in embedding an Excel worksheet in a Publisher publication using the Object command on the Insert menu is to open the publication.

Question 22

The Paste Special command is located on the ____________________ menu.

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

Using the copy and paste integration method, data from Excel or Access become embedded objects in a publication.

Question 29

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

Question 30

A(n) ____________________ object is not connected to its source file.

Question 31

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.

Question 32

Critical Thinking Questions Case SF2-1 Your supervisor, the accounting manager, asks you to insert the current month's sales estimates by product located in an Excel worksheet into a sales report you are creating in Publisher that will be sent 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 33

When working with a linked Excel object in a Publisher publication, double-clicking the object starts the source application, if it is not already running.

Question 34

To make certain that linked objects in a publication always show the most current information, you should ____________________ the links each time you open the publication.

Question 35

Critical Thinking Questions Case SF2-1 Your supervisor, the accounting manager, asks you to insert the current month's sales estimates by product located in an Excel worksheet into a sales report you are creating in Publisher that will be sent to each manager electronically. Which of the following integration methods should you use if each sales manager has access to the source workbook, has permission to change its contents, and are asked to update the source workbook with their latest estimates using the worksheet object in the sales report? ____

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

Question 36

In order to edit the contents of a linked object, you must have access to the source application and file.

Question 37

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 38

When you use the embedding integration method, the source file becomes part of the destination file.

Question 39

When you create a linked object, the source file becomes part of the destination file.

Question 40

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