Question 1

The ____________________ List window displays the database tables and the fields they contain.

Accepted Answer

The answer of The ____________________ List window displays the database...

Question 2

The ____________________ button on the formula bar is one way to easily insert a function into a worksheet cell.

Accepted Answer

insert fun

Question 3

Deleting a field from a form does not delete it from the underlying table nor does it have any effect on the data contained in the field.

Accepted Answer

A) True 
 B)False

Question 4

Major ____ represent the values at the value axis tick marks.

Accepted Answer

A)  Categories 
B)  Axis lines 
C)  Arrows 
D)  Gridlines 
A)  Categories 
B)  Axis lines 
C)  Arrows 
D)  Gridlines

Question 5

Marshall plans to generate reports from an Access table using the Report Wizard. The table contains information about the equipment he uses in his lawn and landscape business, with the following field names:  EquipmentID, EquipmentType (mower, blower, trimmer, so forth), EquipmentDescription, BrandName, SerialNo, DateofPurchase, PurchasePrice. Marshall decides to create a report grouped by brand name (John Deere, Exmark, Ryobi, etc.), and wants to include report, page and group headers. On the report, where does each section print on the page? Give an example of how the report header, page header, and one group header might read.

Accepted Answer

Report Header: prints at the top of the

Question 6

This control is the most common type of control used to display field values.

Accepted Answer

A)  Option button 
B)  Text box 
C)  Combo box 
D)  Option group 
A)  Option button 
B)  Text box 
C)  Combo box 
D)  Option group

Question 7

Which editing keystroke deletes one character to the right of the insertion point?

Accepted Answer

A)  [Backspace] 
B)  [Delete] 
C)  [F2] 
D)  [F7] 
A)  [Backspace] 
B)  [Delete] 
C)  [F2] 
D)  [F7]

Question 8

The Undo button allows you to reverse up to _________ previous actions, one at a time.

Accepted Answer

A)  1 
B)  10 
C)  100 
D)  1,000 
A)  1 
B)  10 
C)  100 
D)  1,000

Question 9

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

Accepted Answer

A)  Cell pointers 
B)  Mode indicators 
C)  Scroll bars 
D)  Sheet tabs 
A)  Cell pointers 
B)  Mode indicators 
C)  Scroll bars 
D)  Sheet tabs

Question 10

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities.What central feature of tables, queries, and forms is not shared by reports?

Accepted Answer

Reports are read-only objects

Question 11

The Group Footer section prints ____.

Accepted Answer

A)  Before every group of records 
B)  After every group of records 
C)  At the top of every page 
D)  At the bottom of every page 
A)  Before every group of records 
B)  After every group of records 
C)  At the top of every page 
D)  At the bottom of every page

Question 12

As shown in the figure above, item 3 is the ___________________ button.

Accepted Answer

The answer of As shown in the figure above, item...

Question 13

Which of the following comparison operators means "greater than"?

Accepted Answer

A) > B) >= C) < D) <= A) > B) >= C) < D) <=

Question 14

In the formula =D1+C1/F3, which calculation will be performed first?

Accepted Answer

A)  C1/F3 
B)  D1+C1 
C)  D1/F3 
D)  D1+F3 
A)  C1/F3 
B)  D1+C1 
C)  D1/F3 
D)  D1+F3

Question 15

Formatting can change the actual data of a cell.

Accepted Answer

A) True 
 B)False

Question 16

A foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Accepted Answer

A) True 
 B)False

Question 17

Functions may be entered for formulas using all of the following methods except _____?

Accepted Answer

A)  the Insert Function button 
B)  the Sum list button 
C)  typing the function 
D)  typing the function argument 
A)  the Insert Function button 
B)  the Sum list button 
C)  typing the function 
D)  typing the function argument

Question 18

Excel recognizes an entry as a value if it is a number or it begins with ____.

Accepted Answer

A)  + 
B)  = 
C)  $ 
D)  All of the above 
A)  + 
B)  = 
C)  $ 
D)  All of the above

Question 19

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

Accepted Answer

A) True 
 B)False

Question 20

The x-axis and y-axis are, respectively, the ____.

Accepted Answer

A)  horizontal and vertical axes 
B)  data series and gridlines 
C)  tick markers and data series 
D)  vertical and horizontal axes 
A)  horizontal and vertical axes 
B)  data series and gridlines 
C)  tick markers and data series 
D)  vertical and horizontal axes

The ____________________ List window displays the database tables and the fields they contain.

The ____________________ button on the formula bar is one way to easily insert a function into a worksheet cell.

Deleting a field from a form does not delete it from the underlying table nor does it have any effect on the data contained in the field.

Major ____ represent the values at the value axis tick marks.

This control is the most common type of control used to display field values.

Which editing keystroke deletes one character to the right of the insertion point?

The Undo button allows you to reverse up to _________ previous actions, one at a time.

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities.What central feature of tables, queries, and forms is not shared by reports?

The Group Footer section prints ____.

As shown in the figure above, item 3 is the ___________________ button.

Which of the following comparison operators means "greater than"?

In the formula =D1+C1/F3, which calculation will be performed first?

Formatting can change the actual data of a cell.

A foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Functions may be entered for formulas using all of the following methods except _____?

Excel recognizes an entry as a value if it is a number or it begins with ____.

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

The x-axis and y-axis are, respectively, the ____.

Understanding Essential Computer

Integrating Word and Excel

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 2: Getting Started With Access 2.0

The ____________________ List window displays the database tables and the fields they contain.

The ____________________ button on the formula bar is one way to easily insert a function into a worksheet cell.

Deleting a field from a form does not delete it from the underlying table nor does it have any effect on the data contained in the field.

Major ____ represent the values at the value axis tick marks.

This control is the most common type of control used to display field values.

Which editing keystroke deletes one character to the right of the insertion point?

The Undo button allows you to reverse up to _________ previous actions, one at a time.

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities.What central feature of tables, queries, and forms is not shared by reports?

The Group Footer section prints ____.

As shown in the figure above, item 3 is the ___________________ button.

Which of the following comparison operators means "greater than"?

In the formula =D1+C1/F3, which calculation will be performed first?

Formatting can change the actual data of a cell.

A foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Functions may be entered for formulas using all of the following methods except _____?

Excel recognizes an entry as a value if it is a number or it begins with ____.

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

The x-axis and y-axis are, respectively, the ____.

Understanding Essential Computer

Integrating Word and Excel

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