Question 1

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.

Accepted Answer

A)  values 
B)  locations 
C)  source code 
D)  data types 
A)  values 
B)  locations 
C)  source code 
D)  data types

Question 2

The ____ domain tells you the type of Web site you are visiting, such as commercial or educational.

Accepted Answer

A)  uniform 
B)  top-level 
C)  URL 
D)  http 
A)  uniform 
B)  top-level 
C)  URL 
D)  http

Question 3

Explain how you can integrate objects that you create in Word, Excel, and Access into PowerPoint presentations that cover a broad spectrum of company activities.

Accepted Answer

You can integrate objects that you creat

Question 4

The proper formula in Excel for multiplying the value in cell B2 with the value in cell C2 is ____.

Accepted Answer

A)  =B2xC2 
B)  =B2%C2 
C)  =B2*C2 
D)  B2*C2 
A)  =B2xC2 
B)  =B2%C2 
C)  =B2*C2 
D)  B2*C2

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

You can speed up the update of values in Excel  linked to an Access table by updating the values manually in the ____ dialog box.

Accepted Answer

A)  Edit Links 
B)  Insert Object 
C)  Paste Special 
D)  Import Data 
A)  Edit Links 
B)  Insert Object 
C)  Paste Special 
D)  Import Data

Question 7

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

Accepted Answer

You use the Copy and Paste commands when

Question 8

You can export a Word outline into PowerPoint to automatically create slides without having to reenter information.

Accepted Answer

A) True 
 B)False

Question 9

You normally break a link when you need to send a file to another user.

Accepted Answer

A) True 
 B)False

Question 10

If you print a Web page, a ____ will appear on the printed copy.

Accepted Answer

A)  timestamp 
B)  URL 
C)  date 
D)  All of the above 
A)  timestamp 
B)  URL 
C)  date 
D)  All of the above

Question 11

A top-level domain tells you the type of site you are visiting.

Accepted Answer

A) True 
 B)False

Question 12

The formula ____ in Excel will calculate the mean of the values in cells B14 through F14.

Accepted Answer

A)  =SUM(B14:F14) 
B)  =MEDIAN(B14:F14) 
C)  =MAX(B14:F14) 
D)  =AVERAGE(B14:F14) 
A)  =SUM(B14:F14) 
B)  =MEDIAN(B14:F14) 
C)  =MAX(B14:F14) 
D)  =AVERAGE(B14:F14)

Question 13

When the Paste Special dialog box is open in Word, select the ____ option to allow for flexible formatting capabilities.

Accepted Answer

A)  Formatted Text (RTF) 
B)  Unformatted Text 
C)  Plain Text 
D)  Unformatted Unicode Text 
A)  Formatted Text (RTF) 
B)  Unformatted Text 
C)  Plain Text 
D)  Unformatted Unicode Text

Question 14

Explain the rules you should observe when opening files created in different applications.

Accepted Answer

When you open files created in different

Question 15

Before exporting data from Excel into Access, you need to remove titles, subtitles, charts, and any other extraneous data.

Accepted Answer

A) True 
 B)False

Question 16

Do all search engines return the same results when you search for a specific keyword or Web page? Why or why not?

Accepted Answer

No. Each search engine differs

Question 17

Text or graphics that you click to open other Web pages, or to play a sound or video, are called ____________________.

Accepted Answer

The answer of Text or graphics that you click to...

Question 18

After exporting Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

Accepted Answer

A)  data cells 
B)  row ids 
C)  record pointers 
D)  field names 
A)  data cells 
B)  row ids 
C)  record pointers 
D)  field names

Question 19

You link an object to a PowerPoint slide when you are the only user of an object, and you want the object to be a part of your presentation.

Accepted Answer

A) True 
 B)False

Question 20

The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

Accepted Answer

A)  (D3 + D2)/D3 
B)  =(D3 + D2)/D3 
C)  (D3-D2)/D3 
D)  =(D3-D2)/D3 
A)  (D3 + D2)/D3 
B)  =(D3 + D2)/D3 
C)  (D3-D2)/D3 
D)  =(D3-D2)/D3

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.

The ____ domain tells you the type of Web site you are visiting, such as commercial or educational.

Explain how you can integrate objects that you create in Word, Excel, and Access into PowerPoint presentations that cover a broad spectrum of company activities.

The proper formula in Excel for multiplying the value in cell B2 with the value in cell C2 is ____.

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

You can speed up the update of values in Excel linked to an Access table by updating the values manually in the ____ dialog box.

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

You can export a Word outline into PowerPoint to automatically create slides without having to reenter information.

You normally break a link when you need to send a file to another user.

If you print a Web page, a ____ will appear on the printed copy.

A top-level domain tells you the type of site you are visiting.

The formula ____ in Excel will calculate the mean of the values in cells B14 through F14.

When the Paste Special dialog box is open in Word, select the ____ option to allow for flexible formatting capabilities.

Explain the rules you should observe when opening files created in different applications.

Before exporting data from Excel into Access, you need to remove titles, subtitles, charts, and any other extraneous data.

Do all search engines return the same results when you search for a specific keyword or Web page? Why or why not?

Text or graphics that you click to open other Web pages, or to play a sound or video, are called ____________________.

After exporting Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

You link an object to a PowerPoint slide when you are the only user of an object, and you want the object to be a part of your presentation.

The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

Understanding Essential Computer

Getting Started With Access 2.0

Getting Started With Microsoft

Finishing a Presentation

Appendix Working With Windows Live and Office Web Apps Question

Getting Started With Windows 7

Creating Documents With Word 2010

Filters

Exam 3: Integrating Word and Excel

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.

The ____ domain tells you the type of Web site you are visiting, such as commercial or educational.

Explain how you can integrate objects that you create in Word, Excel, and Access into PowerPoint presentations that cover a broad spectrum of company activities.

The proper formula in Excel for multiplying the value in cell B2 with the value in cell C2 is ____.

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

You can speed up the update of values in Excel linked to an Access table by updating the values manually in the ____ dialog box.

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

You can export a Word outline into PowerPoint to automatically create slides without having to reenter information.

You normally break a link when you need to send a file to another user.

If you print a Web page, a ____ will appear on the printed copy.

A top-level domain tells you the type of site you are visiting.

The formula ____ in Excel will calculate the mean of the values in cells B14 through F14.

When the Paste Special dialog box is open in Word, select the ____ option to allow for flexible formatting capabilities.

Explain the rules you should observe when opening files created in different applications.

Before exporting data from Excel into Access, you need to remove titles, subtitles, charts, and any other extraneous data.

Do all search engines return the same results when you search for a specific keyword or Web page? Why or why not?

Text or graphics that you click to open other Web pages, or to play a sound or video, are called ____________________.

After exporting Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

You link an object to a PowerPoint slide when you are the only user of an object, and you want the object to be a part of your presentation.

The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

Understanding Essential Computer

Getting Started With Access 2.0

Getting Started With Microsoft

Finishing a Presentation

Appendix Working With Windows Live and Office Web Apps Question

Getting Started With Windows 7

Creating Documents With Word 2010

Filters