Deck 10: Integration 1: Integrating Word and Excel

Question 1

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.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

When you insert an object into a worksheet from another program such as Word, you sometimes need to reposition the current worksheet contents to accommodate the inserted object.

Answer 3

True

Question 4

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

Question 5

You use the Copy and Paste tools to create a link between a chart in Excel and the same chart pasted into a document in Word.

Question 6

To link data other than a chart, you use the Link button and the Paste Special command to create a link between the source file and the destination file.​

Question 7

The difference between linking and embedding relates to where the object is stored and how you update the object after you place it in a document.​

Question 8

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

Question 9

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

Question 10

You use a(n) embed option from the Paste Special dialog box to create a link between selected data in two files.  _________________________

Question 11

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

Question 12

A linked object in a destination file is an image of an object contained in a source file, not a copy of it.

Question 13

You cannot insert a Word file into an Excel worksheet.

Question 14

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

Question 15

When you use the Picture Paste Option to paste a chart, the chart cannot be modified.​

Question 16

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

Question 17

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

Question 18

You can copy charts from Excel to Word but you cannot copy photographs.​

Question 19

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

Question 20

To link data other than a chart, you use the Select button and the Copy Link command to create a link between the source file and the destination file.

Question 21

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 determine that the text value in Word is ____ the source document.

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

Question 22

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

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

Question 23

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

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

Question 24

The Paste Options button labeled ____  is used if you want the pasted chart not to be linked to the source document but you want the pasted chart to assume the formatting of the destination document.

A) Use Destination Theme & Embed Workbook
B) Use Destination Theme & Link Data
C) Keep Source Formatting & Embed Workbook
D) Keep Source Formatting and Link Data

Question 25

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

Question 26

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

Question 27

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

A) Use Destination Theme & Embed Workbook
B) Use Destination Theme & Link Data
C) Keep Source Formatting & Embed Workbook
D) Keep Source Formatting & Link Data

Question 28

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 29

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

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

Question 30

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

Question 31

To link data other than a chart, you use the Copy button and the Update Link command to create a link between the source file and the destination file. _________________________

Question 32

When a chart is pasted into the destination document, the ________ button is selected by default .

A) Keep Source Formatting & Embed Workbook
B) Use Destination Theme & Link Data
C) Use Destination Theme & Embed Workbook
D) Keep Source Formatting & Link Data

Question 33

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

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

Question 34

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

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

Question 35

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 36

Microsoft Office provides ____ integration methods.

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

Question 37

You use the Paste Options button labeled ____  if you want the pasted chart not to be linked to the source document and you want the pasted chart to keep the formatting from the source document.

A) Use Destination Theme & Embed Workbook
B) Use Destination Theme & Link Workbook
C) Keep Source Formatting & Embed Workbook
D) Keep Source Formatting & Link Data

Question 38

You can copy ____ and numbers between Word and Excel.

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

Question 39

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.

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

Question 40

When you use the Copy and Paste commands, by default an object copied from one program to another program retains the ____ of the original object.

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

Question 41

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

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

Question 42

There are three integration methods: ____________________, linking, and embedding.​

Question 43

Both options that allow linking in the Paste Options insert a(n) ____.

A) object break
B) image break
C) line break
D) type break

Question 44

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

Question 45

You use the Copy and ____________________ commands when you want to copy an item from one program to another program.

Question 46

When a Word object is ____ in Excel, the Word Ribbon and tabs appear within the Excel window.

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

Question 47

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

Question 48

To remove items that already appear in the Clipboard task pane, click​ _____. ​

A) ​Remove
B) ​Clear All
C) ​Erase
D) ​Delete

Question 49

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 50

What is OLE?

Question 51

In Word, to manually update links to data in Excel, right-click the link in Word and then click _____. ​

A) ​Refresh
B) ​Update Link
C) ​Manual Update
D) ​Data Update

Question 52

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

Question 53

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 54

You can edit an embedded file by ____ it in the destination program to open the source program.

A) hovering over
B) clicking
C) double-clicking
D) right-clicking

Question 55

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

Question 56

In Excel, the formula ____ will calculate the average of the values in cells B14 through F14.

A) =AVERAGE
B) =AVERAGE[B14:F14]
C) =AVERAGE{B14:F14}
D) =AVERAGE(B14:F14)

Question 57

To refresh an Excel chart's chart data in Word, click the ____ tab, and then click the Refresh Data button in the Data group.

A) OLE
B) Chart Tools Design
C) Link
D) Refresh Data

Question 58

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.

A) Use Destination Theme & Embed Workbook
B) Use Destination Theme & Link Data
C) Keep Source Formatting & Embed Workbook
D) Keep Source Formatting & Link Data

Question 59

In the ____ dialog box, you have more options for pasting a value and controlling its appearance in a destination file.

A) Paste Special
B) Save As
C) Value Format
D) Value Options

Question 60

To link data other than a chart, you use the Copy button and the ____________________ command to create a link between the source file and the destination file.​

Question 64

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. For a value that Eamon has in his Profit worksheet, he wants to make sure that even if the formula changes later, the value will still be accurate in his Word document. Which option should he use to connect this data?
A. linking
B. embedding
C. copying and pasting
D. connecting

Question 65

Explain how you link data other than a chart.

Question 67

To open the Clipboard task pane, click the dialog box launcher in the Clipboard group on the _____ tab.​

A) ​File
B) ​New
C) ​Home
D) ​Edit

Question 69

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 wants to copy the contents of a cell containing a formula in an important Excel worksheet and paste it into the Word document on which he is working. He is expecting that this value may continue to change in Excel for a few more days into his production schedule. Which option should he use to connect this data?
A. linking
B. embedding
C. copying and pasting
D. connecting

Question 70

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

Question 71

How do you embed a file that you create in one Office program into a document created in another Office program? What does this permit you to do?

Question 72

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?
A. linking
B. embedding
C. copying and pasting
D. connecting

Question 73

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. For one set of numbers, Eamon wants to capture the numbers as they are right now, but he is confident that under no circumstance will he want updated numbers to appear in his Word document. Which option should he use?
A. linking
B. embedding
C. copying and pasting from the Clipboard
D. connecting

Question 74

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 a chart from Excel that he put into Word and without doing anything, Word automatically created a relationship between that pasted chart and the original chart. What kind of connection did Word create?
A. a link
B. an embed
C. a paste index
D. a lineage

Question 75

What is the difference between linking and embedding an object?