Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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?

Accepted Answer

A)  a link 
B)  an embed 
C)  a paste index 
D)  a lineage

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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.

Accepted Answer

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 11

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.

Accepted Answer

A) True 
 B)False

Question 12

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.

Accepted Answer

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 13

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

Accepted Answer

The answer of There are three integration methods: ____________________, linking,...

Question 14

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

Accepted Answer

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 15

You cannot insert a Word file into an Excel worksheet.

Accepted Answer

A) True 
 B)False

Question 16

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?

Accepted Answer

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

Question 17

Match between columns
                        Premises: Used to copy and paste more than one item from one program to another program.

Accepted Answer

The Answer of Clipboard and Object Linking and Embedding (OLE) is...

Question 18

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.

Accepted Answer

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

Question 19

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

Accepted Answer

The answer of To link data other than a chart,...

Question 20

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

Accepted Answer

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

Exam 10: Integration 1: Integrating Word and Excel

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

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

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

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

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

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

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

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

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.

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.

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.

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

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

You cannot insert a Word file into an Excel worksheet.

Identify the letter of the choice that best matches the phrase or definition.

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.

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.

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

Exam 10: Integration 1: Integrating Word and Excel

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

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

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

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

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

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

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

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

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.

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.

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.

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

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

You cannot insert a Word file into an Excel worksheet.

Identify the letter of the choice that best matches the phrase or definition.

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.

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

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

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

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

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.