Exam 25: Integration Unit A: Integrating 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 paste the item on the Clipboard with a link to the data source in the Excel document.

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 populate cell F20 with the description Fair/Poor and cell G20 with the sum of the data in cells G16 and G17.

Each time you change a linked value in the source file, the link in the destination file is automatically updated.

In the ____ dialog box, you can choose to paste a value from a source file as a link and you can choose how you want the pasted value to appear in the destination file.

When you copy an object from one program to another, the copied object retains the ____ of the original object.

You can edit a(n) embedded file by double-clicking it in the destination program to open the source program.

When you place multiple items on the Clipboard, newer items appear at the top of the list.

In the list of copied objects shown in the figure above, ____ has been added most recently.

You use the term linked object to refer to ____ data.

The ____________________ file is the file from which information is copied or used.

To link data other than a chart, you use the Copy button and Update Link command to create a link between the source file and the destination file.

If a text value in a Word document is automatically updated after a corresponding text value is updated in an Excel source document, you can infer that the text value in Word is ____ the source document.

Office technology allows you to ____, or place a copy of, the contents of a Word file into an Excel worksheet.

Mary Lou Jacobs, the general manager of QST Vancouver, has recently attempted to update pasted items in the figure below from the source Excel file. The edits made in Excel were not reflected in the Word document. Ms. Jacobs has several questions for you regarding this problem. Why won t the value 250 change after it has been revised in Excel?

If you want to paste an object with a plain text format, you should select ____ in the list box shown in the figure above.

In Excel, the Clipboard task pane opens ____ the spreadsheet window.

If you want to paste an object with a hyperlink to a source document, you should paste the object using the ____ option shown in the figure above.

Explain how you link data other than a chart.

You cannot insert a Word file into an Excel workbook.

You can prepare a report in Word that contains a chart you created in Excel.