Deck 8: Integration Lesson 1: Understanding Integration Fundamentals

Question 1

When you integrate information between programs, the information being shared is referred to as a(n) data source .

Answer 1

False

Question 2

When creating a table in Access using data from an Excel worksheet, Access would be the ____.

A) source program
B) source file
C) destination program
D) destination file

Answer 2

C

Question 3

The source file is not resaved in the destination file when you link.

Answer 3

True

Question 4

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.

Question 5

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

Question 6

Formulas will not be imported from Excel to Access, only the results of the formulas.

Question 7

When you embed an object, the object remains in the source file and you place a link to the object in the destination file.

Question 8

Embedding is useful when the object you are integrating requires tools and features not normally supported by the destination program.

Question 9

Which task is most similar to copying and pasting?

A) Linking
B) Embedding
C) Importing
D) Exporting

Question 10

The main difference between linking and embedding has to do with ____.

A) the size of the source and destination files
B) where the information will be stored and edited
C) how many people will need access to the information
D) when the information will be updated

Question 11

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

A) Excel
B) Chart file
C) PowerPoint
D) Presentation file

Question 12

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.

Question 13

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

Question 14

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

Question 15

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

Question 16

When sharing information between programs, the originating file is called the destination file.

Question 17

To import data, you can use the Mail Merge Wizard in the destination program to guide you through the process.

Question 18

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

Question 19

When you embed an object, there is no connection to the source program.

Question 20

____ is used to make content that is created in the source program available and fully editable in the destination program.

A) The Office Clipboard
B) Mail Merge
C) OLE
D) Exporting

Question 21

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

A) Importing
B) Exporting
C) Linking
D) Embedding

Question 22

When you import from Excel into Access, a copy of the data is brought into Access and stored in a new or existing ____.

A) table
B) query
C) form
D) report

Question 23

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

A) Access table
B) Excel worksheet
C) mail merge document
D) PowerPoint presentation

Question 24

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

A) New Slide
B) Slides from Outline
C) Insert Outline
D) New Outline

Question 25

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?

A) Export - RTF File dialog box
B) Import Spreadsheet Wizard
C) Instruments.rtf file
D) Mail Merge Wizard task pane

Question 26

____________________ is the process of using information in a file created in one program and incorporating it into a file created in another program.

Question 27

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. To start the process, Brayden would click the Start Mail Merge button on the ____ tab in the Start Mail Merge group and then click Step by Step Mail Merge Wizard.

A) Home
B) Insert
C) Page Layout
D) Mailings

Question 28

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.

A) Update Now
B) Locked
C) Break Link
D) Change Source

Question 29

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 ___.

A) on top of the main document
B) in the Mail Merge Recipients dialog box
C) on the right side of the program window
D) above the Ribbon

Question 30

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

A) alphabetic order
B) a new document
C) an existing document
D) the Navigation Pane

Question 31

You can save the steps of a(n) ____ process so they can be easily repeated again in the future without using the wizard.

A) import
B) mail merge
C) linking
D) embedding

Question 32

The source file is duplicated in the destination file and increases the size of the file when you are ____.

A) using the Mail Merge Wizard
B) embedding
C) linking
D) exporting

Question 33

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

A) closed
B) open
C) displayed in the Links dialog box
D) copied to the Clipboard

Question 34

You can export a ____ from Access to a variety of Office programs.

A) table
B) query
C) form
D) table, query, or form

Question 35

When embedding an Excel table in a PowerPoint presentation, you can use the ____ dialog box.

A) Links
B) Mail Merge Recipients
C) Get External Data - Excel Spreadsheet
D) Paste Special

Question 36

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 display the Links dialog box, Tara would click the File tab, click ____, and then click Edit Links to Files.

A) Open
B) Info
C) Publish
D) Edit

Question 37

> is an example of a(n) ____.

A) object
B) merge field
C) source file
D) link

Question 38

The source and destination files must be stored on the same computer or network when you are ____.

A) copying and pasting
B) linking
C) embedding
D) importing

Question 39

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

A) save
B) open
C) break
D) edit

Question 40

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

A) Home
B) Create
C) External Data
D) Database Tools

Question 41

____________________ is an integration technology in Office that allows you to share information between Office programs.

Question 43

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?

Question 44

A(n) ____________________ is used to create a set of documents that are identical except for customized or personalized information in specific areas.

Question 45

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.

Question 46

Placeholders, called ____________________, indicate where the information from the data source will go in the main document.