Exam 2: Getting Started With Access 2.0

You insert a comment in a worksheet by using the ____ tab on the Ribbon.

A(n) ____ is a built-in formula that uses arguments to calculate information.

Charts are updated automatically in Excel whenever data changes.

Which control, when it appears pressed, displays "yes" information?

In this formula,  =(A6*A8)+$D$1, cell references (A6*A8) are relative cell references.

You can resize a chart to improve its appearance by dragging its sizing handles .

You can print a chart by itself or as part of the worksheet.

Differentiate between bound and unbound controls.

This control is used to provide consistent descriptive text as you navigate from record to record.

Which tab and group will allow the insertion of rows and columns in a worksheet?

You can use the Calendar Box to enter dates in a Date/Time field.

In a worksheet, the ____ is called the formula prefix.

A(n) ____________________  is a fundamental building block of a relational database because this object stores all of the data.

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

The Mailing Wizard is a special report wizard that precisely positions and sizes information for hundreds of standard business labels.

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

When you double-click a field in a field list in Query Design View, it is

More than one person can be entering, updating, and using an Access database at the same time.

You can insert a logo on a form using the ____ button on the Design tab.

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.