Exam 2: Getting Started With Access 2.0

Possible paper orientations for printing a worksheet are landscape and ____.

____________________ View is a spreadsheet-like grid that displays a table's fields and records.

Which shortcut key moves focus to the previous field of the current record?

Describe calculation operators, including the different types of calculation operators.

The navigation buttons are found at the top of the datasheet.

A ____________________ is a predefined worksheet formula that enables Excel users to perform complex calculations.

The Report Footer section prints ____.

A chart must be located in a specific cell or at a specific address range.

All Excel formulas begin with the ____.

A mixed reference means that either the column or row reference in the formula is absolute, but not both.

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

The = sign is also called the ____________________ and is automatically inserted when a function is selected.

The phrase "in 3-D" refers to

The term ____ database comes from the fact that two or more tables are linked by a common field.

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

The Format Painter button copies both the cell's content and formatting.

You can move datasheet columns by dragging the field name left or right.

Discuss the guidelines that you should use for planning a chart.

Which chart type would you use to compare distinct objects over time using horizontal bars?

The only way to copy formulas in Excel is to use the Fill Handle of the active cell.