Exam 8: Integration Lesson 1: Understanding Integration Fundamentals

To link an Excel object to a Word document, both need to be ____.

FIGURE INT 1-1 When you click the Save button in the dialog box shown in Figure INT 1-1 above, what will be displayed on the screen?

If you have a file that contains outline text with heading styles, you can use it to create the basic structure of a(n) ____.

When you ____ the link, the object in the destination file will become just a static copy of the original object.

In Access, on the ____ tab, in the Import & Link group, you can click the Excel button to start importing data.

When you export from Access to Word, the data is always displayed in ____.

If you wanted to share information between Office programs, what methods would you have available? What kinds of things would you need to consider when deciding which one to use?

When you link an object, you place a copy of the object in the destination file that is no longer connected to the original object in the source file.

Importing and exporting are one-time operations--there is no connection established between the two programs.

A destination file cannot display linked data without being able to access the source file .

When you import information, you transfer data from the source file to a destination file in a format that can be used by the destination file.

You can lock a link to temporarily prevent it from being updated.

Which dialog box do you use when creating slides based on outline text?

Case INT 1-1 In the past, Tara frequently needed to update a Word report with sales data from Excel, so she inserted a linked table into the document. Now that she no longer needs the object to be linked, she wants to break the link. To break the link, Tara would select it in the Links dialog box, and then click the ____ button.

FIGURE INT 1-1 The dialog box shown in Figure INT 1-1 above would be displayed during the process of performing which task?

An Excel worksheet can be used as a data source in a mail merge operation.

When you insert an Excel chart into a PowerPoint slide, which of the following is the source program?

The source file should be open before you begin importing data from it.

Case INT 1-2 Brayden plans to use the Mail Merge Wizard to create personalized form letters to send out to each of his clients announcing the grand opening of his new office. When Brayden opens the Mail Merge Wizard task pane in Word, it will be displayed ___.

When you ____________________ information, you transfer source data into a destination file, changing the data's format or characteristics in such a way that it can be viewed, edited, or otherwise manipulated using the destination program.