Exam 10: Integration 1: Integrating Word and Excel

The Paste Options button labeled ____ is selected by default when a chart is pasted into a destination document.

When you copy and paste an object, changes that you make to the object in the source file appear in the destination file.

You can copy ____ and numbers between Word and Excel.

By default, when you copy an Excel report into Word, it will be formatted with the same theme applied to the source document. _________________________

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

As you paste a chart from Excel to Word use the Paste Options button labeled ____  if you want the theme of the destination document applied to the chart, and the chart is linked to the object in the source document.

The term linked object is used to refer to connected data in two or more files.​ ____________________

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

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

Suppose you have placed the following items to the Clipboard in the following order: 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.

When you embed a Word file into an Excel worksheet, you place an ____________________ copy of the ​Word file into the worksheet.

Explain how you link data other than a chart.

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

Microsoft Office provides ____ integration methods.

The two options that allow linking are Link & Keep Source Formatting and Link & Merge Formatting.​

By default, an object copied from one program to another program retains the formatting of the original object and is not linked to the original object.​

The Paste list arrow in the Insert group allows you to see each of the six Paste Options and to view how the pasted object will appear in the document.

When you open a Word file that contains links from an Excel file, a dialog box opens with a message telling you that the document contains links that may refer to other files.​

Critical Thinking Questions Case 1-1 Eamon Christopher, the new staff assistant at R2G, wants to create some new reports utilizing the features of each of the various Microsoft Office programs using OLE technology. Eamon has put a Word file into an Excel worksheet and he can edit the file using Word program tools to change text and formatting. Which method did he use to integrate Word and Excel in this case?