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

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.

Access 1: Getting Started With Access

Access 2: Building and Using Queries

Access 3: Using Forms

Access 4: Using Reports

Essential: Understanding Essential Computer Concepts

Excel 1: Getting Started With Excel 2016

Excel 2: Working With Formulas and Functions

Excel 3: Formatting a Worksheet

Excel 4: Working With Charts

Integration 2: Integrating Word Excel and Access

Integration 3: Integrating Word Excel Access and Powerpoint

Office: Getting Started With Office 2016

Outlook 1: Getting Started With Email

Outlook 2: Managing Information Using Outlook

Powerpoint 1: Creating a Presentation in Powerpoint 2016

Powerpoint 2: Modifying a Presentation

Powerpoint 3: Inserting Objects Into a Presentation

Powerpoint 4: Finishing a Presentation

Windows 1: Getting Started With Windows 10

Windows 2: Understanding File Management

Word 1: Creating Documents With Word 2016

Word 2: Editing Documents

Word 3: Formatting Text and Paragraphs

Word 4: Formatting Documents

Filters

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.