Question 1

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

Accepted Answer

False

Question 2

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

Accepted Answer

Embedded objects can be edited, but changes will only appear in the document where they are embedded, not in the source file.

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

Accepted Answer

When you open a publication containing a linked worksheet object, Publisher automatically tries to locate the source file. Excel is the source file, but it doesn't try to locate itself. Word and Access also do not automatically try to locate the source file.

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

Accepted Answer

Embedding creates a copy of the data within the object, so it remains unchanged even if the source file is modified.

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

Accepted Answer

The correct option to create a linked object using the Paste Special command is the "Paste Link" option button. This will ensure that any changes made to the original object will also be reflected in the linked object in the new location.

Question 6

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

Accepted Answer

The original file is called the source file, not the destination file, when integrating information between two Office applications.

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

Accepted Answer

The answer of The ____ method is sometimes the better...

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

Accepted Answer

Linking refers to creating a connection between a source file and a destination file, allowing the destination file to display a representation of the source file.

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

Accepted Answer

When you paste Excel worksheet data into a Publisher publication, it is best to paste it into a table. This will help keep the data organized and aligned properly within the publication.

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

Accepted Answer

Embedding means inserting a source file into a destination publication as an object that can be edited with source application tools within the destination application. This differs from pasting, which simply creates a static image of the source file, and linking, which creates a connection between the source and destination files but does not allow for editing within the destination application. Saving is a general term that refers to storing a file or document.

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

Accepted Answer

Linking allows the object to reflect any changes made in the source file. Copy and Pasting creates a separate instance of the object and will not reflect changes made in the source file. Embedding and Inserting also create separate instances and do not reflect changes made in the source file.

Question 12

A workbook consists of cells organized into columns and rows.

Accepted Answer

The answer of A workbook consists of cells organized into...

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

Accepted Answer

The linked object is not the location where editing takes place. The VBA window is not relevant to editing linked objects. The destination publication displays the linked object and any changes made to it in the source file, but editing itself must occur in the source file to ensure accuracy and consistency throughout all linked instances of the object. Therefore, the best choice is the source file.

Question 14

____ most embedded objects displays the object's source application commands.
A) Clicking
B) Double-clicking
C) Triple-clicking
D) Right-clicking

Accepted Answer

Double-clicking an embedded object typically opens it in its source application, displaying the application's commands.

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

Accepted Answer

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

Question 16

Many worksheets can be stored in an Excel workbook.

Accepted Answer

Excel workbooks can contain and organize multiple worksheets.

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

Accepted Answer

The image shows an Excel work area with columns and rows, which is commonly known as a worksheet. Therefore, option A, "worksheet," is the best choice. Option B, "workbook," refers to a collection of one or more worksheets and is not specific to the image. Option C, "document," and option D, "publication," are not appropriate choices for an Excel work area.

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

Accepted Answer

The Link command is typically found under the Edit menu in many software applications, allowing users to manage and update links to external files.

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

Accepted Answer

The accompanying figure shows the Ribbon displayed when opening an embedded object for editing in Excel.

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

Accepted Answer

OLE (Object Linking and Embedding) is the technology that allows you to paste, embed, or link a file or partial file created in one Office application into a different Office application. It is commonly used in Microsoft Office Suite for integrating different types of data from different applications.

Quiz 8: Integration Feature - Object Linking and Embedding

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

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

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

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.

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.

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

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

____ 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 copy and then paste Excel worksheet data into a publication, the data is pasted into a Publisher ____.

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

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

A workbook consists of cells organized into columns and rows.

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

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

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

Many worksheets can be stored in an Excel workbook.

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

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

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

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