Deck 25: Integration Unit A: Integrating Word and Excel

Question 1

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

Answer 1

False

Question 2

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

Answer 2

False

Question 3

When you want to copy an object without a data connection to the source file, you should use the ____ integration method.

A) linking
B) inline
C) pasting
D) compacting

Answer 3

C

Question 4

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

Question 5

When you link a chart from Excel to Word, you can update only the chart style .

Question 6

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

Question 7

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

Question 8

Microsoft Office provides ____ integration methods.

A) three
B) four
C) five
D) six

Question 9

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

Question 10

Microsoft Office programs are designed to work together through a process called ____.

A) validation
B) integration
C) certification
D) authentication

Question 11

You cannot insert a Word file into an Excel workbook.

Question 12

You use the Copy and Paste buttons to create a link between a chart that you copy from Excel and paste into a document in Word.

Question 13

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

Question 14

The Paste Special command only allows one format for a linked object.

Question 15

You can copy ____ and numbers between Word and Excel.

A) ribbons
B) commands
C) words
D) formula bars

Question 16

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.

Question 17

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

Question 18

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

Question 19

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.

A) embedded in
B) linked to
C) copied to
D) pasted to

Question 20

When you integrate data from multiple Office programs, you work with both a source file and a destination file.

Question 21

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

A) augment
B) compress
C) embed
D) convert

Question 22

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

A) to the left of
B) to the right of
C) above
D) below

Question 23

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

A) 8
B) 12
C) 16
D) 24

Question 24

The chart shown in the figure above will reflect ____ updates made to the source chart in Excel.

A) color
B) font size
C) data
D) font type

Question 25

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

A) binary
B) destination
C) image
D) zipped

Question 26

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

A) Paste All
B) Clear All
C) Select All
D) Delete

Question 27

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

A) connected
B) encrypted
C) binary
D) variable

Question 28

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

A) Total Tours 250
B) the photograph
C) QST Vancouver
D) Great Satisfaction Survey Results

Question 29

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

A) recover
B) link
C) redefine
D) capture

Question 30

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

A) command tab
B) title bar
C) ribbon
D) Clipboard

Question 31

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.

A) Paste Special
B) Save As
C) Copy
D) Replace

Question 32

In the list of ____ options shown by item 2 in the figure above, the link option is selected by default.

A) Copy
B) Paste
C) Cut
D) Clipboard

Question 33

Because the pasted object pointed to by item 3 in the Word document shown above is a ____, it is automatically linked to its source object in Excel.

A) chart
B) text selection
C) picture
D) value

Question 34

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

A) =SUM(B14:F14)
B) =MEDIAN(B14:F14)
C) =MAX(B14:F14)
D) =AVERAGE(B14:F14)

Question 35

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

A) Paste
B) Paste link
C) Paste Special
D) Paste All

Question 36

The icon pointed to by item 1 in the figure above represents the ____ button.

A) Paste Special
B) Edit Picture
C) Paste Options
D) Object

Question 37

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

A) text value
B) table
C) photograph
D) column chart

Question 38

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

A) photograph
B) text value
C) chart
D) range of cell values

Question 39

Because the value 75% pointed to by item 2 in the figure above is connected to a value in a source Excel file, the value is called a(n) ____ object.

A) copied
B) embedded
C) edited
D) linked

Question 40

If you wanted to place a copy of the Word file for the document shown in the figure above into an Excel worksheet, you would perform a(n) ____ operation.

A) linking
B) conversion
C) embedding
D) formatting

Question 41

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

A) status bar
B) title bar
C) Word tabs
D) source document

Question 42

Because the embedded object shown in the figure above is not linked to the source object, edits made in the embedded object ____.

A) will be automatically reflected in the source file
B) will not be reflected in the source file
C) will be reflected in the source object after a link update
D) will be reflected in the source file when the source file is opened

Question 43

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

A) Unformatted Text
B) Formatted Text (RTF)
C) Bitmap
D) HTML Format

Question 44

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

A) Paste
B) Paste link
C) Display as icon
D) Paste Special

Question 45

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

A) address
B) formatting
C) record
D) link to the source

Question 46

How do you enable a file extension such as .docx to appear after a filename in the directory?

Question 47

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.

A) Picture (Enhanced Metafile)
B) Picture (Windows Metafile)
C) HTML Format
D) Unformatted Unicode Text

Question 48

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

A) interpreted
B) assembly
C) source
D) destination

Question 49

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

A) 1
B) 2
C) 3
D) 4

Question 50

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

Question 51

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

Question 52

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

Question 53

What is the difference between linking and embedding an object?

Question 54

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

A) link
B) hide
C) associate
D) embed

Question 55

Explain how you link data other than a chart.

Question 56

In the figure shown above, item ____ points to information that indicates Excel is the destination program.

A) 1
B) 2
C) 3
D) 4

Question 57

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

Question 58

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.

Question 59

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

Question 60

Provide an example of why you might want to link data included in two or more files.

Question 61

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 copy the contents of cell G20 to the Clipboard and then prepare for pasting at the proper location in the destination Word document.

Question 63

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?

Question 64

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.

Question 65

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.

Question 66

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?