Exam 25: Integration Unit A: Integrating Word and Excel

Because the embedded object shown in the figure above is not linked to the source object, edits made in the embedded object ____.

You use the Copy and Paste buttons to create a link between a chart that you copy from Excel and paste into a document in Word.

When and how do you use the Copy and Paste commands to integrate data?

After you create an object in one program, you can choose to either ____ the object or embed it in another program.

Microsoft Office programs are designed to work together through a process called ____.

When you integrate data from multiple Office programs, you work with both a source file and a destination file.

You can "collect" up to ____ items to the Clipboard and then switch to the other program to paste them.

Because the value 75% pointed to by item 2 in the figure above is connected to a value in a source Excel file, the value is called a(n) ____ object.

How do you enable a file extension such as .docx to appear after a filename in the directory?

Suppose you have placed the following items to the Clipboard: a photograph, a text value, a column chart, and a table. If the items were copied in the order listed, the ____ would be at the bottom of the list.

In the list of ____ options shown by item 2 in the figure above, the link option is selected by default.

Provide an example of why you might want to link data included in two or more files.

Because the pasted object pointed to by item 3 in the Word document shown above is a ____, it is automatically linked to its source object in Excel.

The Paste Special command only allows one format for a linked object.

Microsoft Office provides ____ integration methods.

The icon pointed to by item 1 in the figure above represents the ____ button.

The chart shown in the figure above will reflect ____ updates made to the source chart in Excel.

You can copy ____ and numbers between Word and Excel.

Mary Lou Jacobs has requested that additional information be included in the report shown in the figure below. She has added the text Only of our guests rated the QST tour experience as either Fair or Poor to the bottom of the Word document. You need to fill the space after Only with the percentage of Fair or Poor responses from the source Excel spreadsheet. To carry out the tasks, you will need to apply your knowledge of OLE technology. Describe how to copy the contents of cell G20 to the Clipboard and then prepare for pasting at the proper location in the destination Word document.