Exam 25: Integration Unit A: Integrating Word and Excel

The Word tabs and ribbon activated after double-clicking the embedded object shown in the figure above are pointed to by item ____.

To open the Clipboard task pane in Excel or Word, you can click the ____________________ in the Clipboard group.

You use the Embed command from the Paste Special dialog box to create a link between selected data in two files.

In the dialog box shown in the figure above, you should select ____ to create a link with the source object.

When you point to an Excel program button on the taskbar, the program name and filename appear in a(n) ____________________.

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. If there is no data connection between the table in Word containing Total Tours 250, and the source cells in Excel, why do the table and source cells have an identical appearance?

You can ____ an entire file that you create in one Office program in a document created in another Office program.

If you need to remove all items appearing in the Clipboard task pane, click ____.

The photograph shown in the figure will be copied into a(n) ____ file.

When you are embedding an object in a file, the ____________________ dialog box gives you the option of either creating a new object or inserting an object from a file.

If a pasted object is linked by default to the source file, you can infer that the object is a(n) ____.

In the figure above, the pane pointed to by item 1 is known as the ____.

You can choose to insert a Word object anywhere in an Excel spreadsheet.

When you double-click the embedded object shown in the figure above, you open its ____ program.

You open the dialog box shown in the figure above by selecting the ____ item from the Paste list arrow menu.

The formula ____ in Excel will calculate the mean of the values in cells B14 through F14.

When a Word object is embedded in an Excel file, you can use the tools from the source program (Word) to edit it.

When you are editing an embedded file, you can determine the name of the destination file by examining the ____.

Integration allows information created in one program to be reused in other programs.

When you change data in a source file, linked data also changes in the ____________________ file.