Question 1

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result:  =22/2*5  =22/(2*5).

Accepted Answer

A) True 
 B)False

Question 2

To move one screen to the left press ____.

Accepted Answer

A)  [Ctrl][Home] 
B)  [Alt][Page Up] 
C)  [Ctrl][Page Left] 
D)  [Alt][Page Down] 
A)  [Ctrl][Home] 
B)  [Alt][Page Up] 
C)  [Ctrl][Page Left] 
D)  [Alt][Page Down]

Question 3

Which data type is used to sequentially order each record added to a table?

Accepted Answer

A)  Hyperlink 
B)  Web 
C)  Lookup Wizard 
D)  AutoNumber 
A)  Hyperlink 
B)  Web 
C)  Lookup Wizard 
D)  AutoNumber

Question 4

Which of the following will not be affected or rearranged by choosing a new layout on the Chart Tools Design tab?

Accepted Answer

A)  Data 
B)  Legend 
C)  Titles 
D)  Gridlines 
A)  Data 
B)  Legend 
C)  Titles 
D)  Gridlines

Question 5

____________________ box controls are used to display and edit data on a form.

Accepted Answer

The answer of ____________________ box controls are used to display...

Question 6

To find all records where there is any entry in the field, even if the entry is 0, use which criteria?

Accepted Answer

A)  0 
B)  Is Not Null 
C)  *=* 
D)  * * 
A)  0 
B)  Is Not Null 
C)  *=* 
D)  * *

Question 7

You can apply formatting before or after you enter data in a cell or range.

Accepted Answer

A) True 
 B)False

Question 8

Which method of entering a function requires the user to know the name and initial characters of a function?

Accepted Answer

A)  manually typing the function 
B)  using the Insert Function button 
C)  using the Sum button 
D)  using the Sum list arrow 
A)  manually typing the function 
B)  using the Insert Function button 
C)  using the Sum button 
D)  using the Sum list arrow

Question 9

A query is commonly used as the source of data for a form or report.

Accepted Answer

A) True 
 B)False

Question 10

The cell in which you are working is called the ____________________ cell.

Accepted Answer

The answer of The cell in which you are working...

Question 11

Enter OR criteria on different Criteria rows in the query design grid.

Accepted Answer

A) True 
 B)False

Question 12

Describe some of the changes that you can make to a chart using the Chart Tools Design tab.

Accepted Answer

Using the Chart Tools Design t

Question 13

This Access object provides an easy-to-use data entry screen.

Accepted Answer

A)  Macro 
B)  Form 
C)  Table 
D)  Module 
A)  Macro 
B)  Form 
C)  Table 
D)  Module

Question 14

A filter can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 15

Which type of cell reference preserves the exact cell address in a formula?

Accepted Answer

A)  absolute 
B)  mixed 
C)  relative 
D)  All of the above 
A)  absolute 
B)  mixed 
C)  relative 
D)  All of the above

Question 16

Excel templates include which of these categories?

Accepted Answer

A)  budgets 
B)  timesheets 
C)  expense reports 
D)  All of the above 
A)  budgets 
B)  timesheets 
C)  expense reports 
D)  All of the above

Question 17

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow.

Accepted Answer

A) True 
 B)False

Question 18

A named range may begin a letter or number.

Accepted Answer

A) True 
 B)False

Question 19

Calculated expressions within text boxes start with an equal sign.

Accepted Answer

A) True 
 B)False

Question 20

Bound controls exist only to clarify or enhance the appearance of the form.

Accepted Answer

A) True 
 B)False

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/25 =22/(25).

To move one screen to the left press ____.

Which data type is used to sequentially order each record added to a table?

Which of the following will not be affected or rearranged by choosing a new layout on the Chart Tools Design tab?

____________________ box controls are used to display and edit data on a form.

To find all records where there is any entry in the field, even if the entry is 0, use which criteria?

You can apply formatting before or after you enter data in a cell or range.

Which method of entering a function requires the user to know the name and initial characters of a function?

A query is commonly used as the source of data for a form or report.

The cell in which you are working is called the ____________________ cell.

Enter OR criteria on different Criteria rows in the query design grid.

Describe some of the changes that you can make to a chart using the Chart Tools Design tab.

This Access object provides an easy-to-use data entry screen.

A filter can be used to create calculated fields.

Which type of cell reference preserves the exact cell address in a formula?

Excel templates include which of these categories?

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow.

A named range may begin a letter or number.

Calculated expressions within text boxes start with an equal sign.

Bound controls exist only to clarify or enhance the appearance of the form.

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

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).

To move one screen to the left press ____.

Which data type is used to sequentially order each record added to a table?

Which of the following will not be affected or rearranged by choosing a new layout on the Chart Tools Design tab?

____________________ box controls are used to display and edit data on a form.

To find all records where there is any entry in the field, even if the entry is 0, use which criteria?

You can apply formatting before or after you enter data in a cell or range.

Which method of entering a function requires the user to know the name and initial characters of a function?

A query is commonly used as the source of data for a form or report.

The cell in which you are working is called the ____________________ cell.

Enter OR criteria on different Criteria rows in the query design grid.

Describe some of the changes that you can make to a chart using the Chart Tools Design tab.

This Access object provides an easy-to-use data entry screen.

A filter can be used to create calculated fields.

Which type of cell reference preserves the exact cell address in a formula?

Excel templates include which of these categories?

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow.

A named range may begin a letter or number.

Calculated expressions within text boxes start with an equal sign.

Bound controls exist only to clarify or enhance the appearance of the form.

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

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/25 =22/(25).