Question 1

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.

Accepted Answer

The answer of Mary Lou Jacobs has requested that additional...

Question 2

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.

Accepted Answer

The answer of Mary Lou Jacobs has requested that additional...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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.

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

The answer of The ____________________ file is the file from...

Question 11

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.

Accepted Answer

A) True 
 B)False

Question 12

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.

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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?

Accepted Answer

The answer of Mary Lou Jacobs, the general manager of...

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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.

Accepted Answer

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

Question 18

Explain how you link data other than a chart.

Accepted Answer

The answer of Explain how you link data other than...

Question 19

You cannot insert a Word file into an Excel workbook.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 25: Integration Unit A: Integrating Word and Excel

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

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.

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

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

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

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

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

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

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.

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.

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

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

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

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.

Explain how you link data other than a chart.

You cannot insert a Word file into an Excel workbook.

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