Exam 2: Getting Started With Access 2.0

When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.

Excel Unit B demonstrated the use of several functions: AVERAGE, MAX, COUNT, and COUNTA. Explain how the COUNT and COUNTA functions work.

The same expression in different report sections will calculate using a different number of records.

You are in Edit mode any time you are entering or changing the contents of a cell.

The Auto Fill feature of Excel only allows the user to fill cells with a series using the existing formatting options of the cell.

The file extension .xltx indicates what type of Excel file?

The ____________________ source is the table or query that defines the fields and records displayed on a report.

Relational ____________________ software is used to manage data that can be organized into lists of related information such as customers, products, vendors, employees, projects, or sales.

When the mouse pointer hovers over any chart object, the name of the selected object appears on screen as a(n) ____________________.

The connection between the text box and field is defined by the Control Source property.

Discuss the difference between a relative cell reference and an absolute cell reference. Include the following information in your answer: how the two types of cell addresses are designated, what happens when each type of cell reference is copied, and when it is appropriate to use each type of reference.

WordArt, which lets you create curved or stylized text, can be created using the Chart Tools Format tab.

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

When you modify controls, you change their ____________________ (characteristics).

You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is by using the Border and Fill Color buttons in the Font group on the ____ tab of the Ribbon.

A collection of related data points is called a ____.

The Navigation buttons on a datasheet display the total number of fields in the datasheet.

Field names appear in the top row of a datasheet.

To complete the days of the week sequence that begins with the days Monday, Tuesday; the Excel user would select the cells containing Monday and Tuesday and use the ____________________ to complete the sequence.

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.