Question 1

You can enter, edit, and navigate data in a query datasheet just like a report datasheet.

Accepted Answer

A) True 
 B)False

Question 2

In Form Layout View, you can move through records and view data, but you cannot enter or edit data.

Accepted Answer

A) True 
 B)False

Question 3

Which report creation tool is similar to the Form Wizard?

Accepted Answer

A)  Report Design View 
B)  Report Layout View 
C)  Object Wizard 
D)  Report Wizard 
A)  Report Design View 
B)  Report Layout View 
C)  Object Wizard 
D)  Report Wizard

Question 4

To find numbers greater than or equal to 500, use which comparison operator?

Accepted Answer

A)  $ \neq $ 
B)  > 
D)  >= 
A)  $ \neq $ 
B)  > 
D)  >=

Question 5

To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

Accepted Answer

A) True 
 B)False

Question 6

The Group Header and Group Footer section can be turned on or off in which pane?

Accepted Answer

A)  Properties 
B)  Field List 
C)  Toolbox 
D)  Group, Sort, and Total 
A)  Properties 
B)  Field List 
C)  Toolbox 
D)  Group, Sort, and Total

Question 7

____________________ orientation is 11" wide by 8.5" tall.

Accepted Answer

The answer of ____________________ orientation is 11" wide by 8.5"...

Question 8

Which section would most likely contain page number and date expressions?

Accepted Answer

A)  Report Header 
B)  Group Header 
C)  Detail 
D)  Page Footer 
A)  Report Header 
B)  Group Header 
C)  Detail 
D)  Page Footer

Question 9

Any edits you make in a query datasheet are permanently stored in the underlying relationships .

Accepted Answer

A) True 
 B)False

Question 10

This control is used to display "yes" or "no" answers for a field.

Accepted Answer

A)  Check box 
B)  List box 
C)  Combo box 
D)  Option box 
A)  Check box 
B)  List box 
C)  Combo box 
D)  Option box

Question 11

The only categories of functions available in Excel 2010 are financial and statistical.

Accepted Answer

A) True 
 B)False

Question 12

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

Accepted Answer

A)  SUM function 
B)  redo 
C)  fill handle 
D)  copy/paste 
A)  SUM function 
B)  redo 
C)  fill handle 
D)  copy/paste

Question 13

Describe Excel's AutoRecover feature.

Accepted Answer

Sometimes while you are using Excel, you

Question 14

When the paper orientation is portrait , the contents will print across the length of the page instead of across the width.

Accepted Answer

A) True 
 B)False

Question 15

Controls placed in this form section print once for every record in the underlying object.

Accepted Answer

A)  Form Records 
B)  Form Header 
C)  Form Footer 
D)  Detail 
A)  Form Records 
B)  Form Header 
C)  Form Footer 
D)  Detail

Question 16

The wildcard character that stands for any group of characters is the ____.

Accepted Answer

A)  Period (.) 
B)  Semicolon (;) 
C)  Asterisk (*) 
D)  Plus sign (+) 
A)  Period (.) 
B)  Semicolon (;) 
C)  Asterisk (*) 
D)  Plus sign (+)

Question 17

Match between columns
                        Premises: Allows the user to move or copy data from one cell to another without using the Clipboard.
The Excel function that returns the number of cells in a range containing numeric data.
Mixed cell reference.
Absolute cell reference.
Predesigned workbook files that contain labels, values, formulas, and formatting.
The type of cell reference used to preserve the relationship to the formula location.
The Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paste formulas only."
The Excel function that returns the arithmetic mean of its arguments.

Accepted Answer

The Answer of AVERAGE and Paste Preview and template and is...

Question 18

Cell templates are sets of cell formats based on themes; they are automatically updated if you change a theme.

Accepted Answer

A) True 
 B)False

Question 19

You can apply attributes and alignment options using the ____ dialog box.

Accepted Answer

A)  Format Cells 
B)  Insert 
C)  Conditional Formatting 
D)  AutoCorrect 
A)  Format Cells 
B)  Insert 
C)  Conditional Formatting 
D)  AutoCorrect

Question 20

Expressions must start with what character?

Accepted Answer

A)  [ left square bracket 
B)  = equal sign 
C)  ( left parenthesis 
D)  : colon 
A)  [ left square bracket 
B)  = equal sign 
C)  ( left parenthesis 
D)  : colon

You can enter, edit, and navigate data in a query datasheet just like a report datasheet.

In Form Layout View, you can move through records and view data, but you cannot enter or edit data.

Which report creation tool is similar to the Form Wizard?

To find numbers greater than or equal to 500, use which comparison operator?

To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

The Group Header and Group Footer section can be turned on or off in which pane?

____________________ orientation is 11" wide by 8.5" tall.

Which section would most likely contain page number and date expressions?

Any edits you make in a query datasheet are permanently stored in the underlying relationships .

This control is used to display "yes" or "no" answers for a field.

The only categories of functions available in Excel 2010 are financial and statistical.

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

Describe Excel's AutoRecover feature.

When the paper orientation is portrait , the contents will print across the length of the page instead of across the width.

Controls placed in this form section print once for every record in the underlying object.

The wildcard character that stands for any group of characters is the ____.

Cell templates are sets of cell formats based on themes; they are automatically updated if you change a theme.

You can apply attributes and alignment options using the ____ dialog box.

Expressions must start with what character?

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

You can enter, edit, and navigate data in a query datasheet just like a report datasheet.

In Form Layout View, you can move through records and view data, but you cannot enter or edit data.

Which report creation tool is similar to the Form Wizard?

To find numbers greater than or equal to 500, use which comparison operator?

To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

The Group Header and Group Footer section can be turned on or off in which pane?

____________________ orientation is 11" wide by 8.5" tall.

Which section would most likely contain page number and date expressions?

Any edits you make in a query datasheet are permanently stored in the underlying relationships .

This control is used to display "yes" or "no" answers for a field.

The only categories of functions available in Excel 2010 are financial and statistical.

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

Describe Excel's AutoRecover feature.

When the paper orientation is portrait , the contents will print across the length of the page instead of across the width.

Controls placed in this form section print once for every record in the underlying object.

The wildcard character that stands for any group of characters is the ____.

Cell templates are sets of cell formats based on themes; they are automatically updated if you change a theme.

You can apply attributes and alignment options using the ____ dialog box.

Expressions must start with what character?

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