Question 1

The Paste list arrow in the Insert group allows you to see each of the five Paste Options and to view how the pasted object will appear in the document.

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

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

Question 3

You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.

Accepted Answer

A)   current
B)   static
C)   secure
D)   encrypted A

Question 4

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

Accepted Answer

The answer of Provide an example of why you might...

Question 5

If you want to import additional records to an existing database, make sure that the imported Excel data contains the same number of ____________________ as the database.

Accepted Answer

The answer of If you want to import additional records...

Question 6

When you double-click an embedded object, you can use the tools of the destination program to edit the object.

Accepted Answer

A) True 
 B)False

Question 7

After an Excel worksheet is embedded in a PowerPoint slide, how is the worksheet identified and displayed?

Accepted Answer

The answer of After an Excel worksheet is embedded in...

Question 8

When you embed an object, you create a link to the source file.

Accepted Answer

A) True 
 B)False

Question 9

The term 'load' is often used to describe opening a page in a ____.

Accepted Answer

A)   title bar
B)   site page
C)   Web page
D)   browser

Question 10

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 11

If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object's source file.

Accepted Answer

A)   encrypt
B)   decrypt
C)   link
D)   embed

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

If you want to close Internet Explorer but have serveral tabs open, you will be asked if you want to close all the tabs or just current the current tab.

Accepted Answer

A) True 
 B)False

Question 14

If you want to select from a variety of formatting options when pasting an object into Word, you should use the Paste Format command.

Accepted Answer

A) True 
 B)False

Question 15

To edit an embedded object, you ____ it.

Accepted Answer

A)   single-click
B)   double-click
C)   control-click
D)   highlight

Question 16

Microsoft Office provides ____ integration methods.

Accepted Answer

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

Question 17

Jane is using the Internet to do research for a term paper for her literature course.She has found that many of the pages she looks at have links to similar pages and before long has gotten lost in a maze of Web sites. Jane is having difficulty keeping track of all the different Web sites she has open.How can she take advantage of tabbed browsing to ensure that she doesn't lose track of any pages?

Accepted Answer

The answer of Jane is using the Internet to do...

Question 18

By default, when you print a Web page the current ____ appears in the header and footer.

Accepted Answer

A)   Links, date and time
B)   URL, Search Engine, and time
C)   URL, date and time
D)   URL, username, date and time

Question 19

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 20

You can increase efficiency by integrating the information you create in Word, Excel, and Access.

Accepted Answer

A) True 
 B)False

Exam 3: Integrating Word and Excel

The Paste list arrow in the Insert group allows you to see each of the five Paste Options and to view how the pasted object will appear in the document.

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

You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.

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

If you want to import additional records to an existing database, make sure that the imported Excel data contains the same number of ____________________ as the database.

When you double-click an embedded object, you can use the tools of the destination program to edit the object.

After an Excel worksheet is embedded in a PowerPoint slide, how is the worksheet identified and displayed?

When you embed an object, you create a link to the source file.

The term 'load' is often used to describe opening a page in a ____.

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.

If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object's source file.

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

If you want to close Internet Explorer but have serveral tabs open, you will be asked if you want to close all the tabs or just current the current tab.

If you want to select from a variety of formatting options when pasting an object into Word, you should use the Paste Format command.

To edit an embedded object, you ____ it.

Microsoft Office provides ____ integration methods.

By default, when you print a Web page the current ____ appears in the header and footer.

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

You can increase efficiency by integrating the information you create in Word, Excel, and Access.