Excel Ch. 2

A cell reference that refers to a cell by its fixed position in a worksheet and that does not change when the formula is copied.

Absolute cell reference

The value(s) that determine how a function should be used.

Argument

Automatically changing the column width to accommodate the longest column entry.

AutoFit

The function that adds a group of values and then divides the result by the number of values in the group.

Average function

A chart line that contains words as labels.

Category axis

A graphical representation of data in a worksheet that shows comparisons, patterns, and trends.

Chart

A predesigned combination of chart elements.

Chart layout

A worksheet that contains only a chart.

Chart sheet

A pre-built chart format that applies an overall visual look to a chart.

Chart style

A chart type useful for illustrating comparisons among related numbers.

Column chart

The related data points in a chart.

Data series

A chart placed on a worksheet with the source data.

Embedded chart

A green triangle that indicates a possible error in a formula.

Error indicator

The default format applied to numbers.

General format

The box that identifies the patterns or colors assigned to the data series.

Legend

Rules that specify the way numbers should display.

Number format

The chart type that best displays the relationship of parts to a whole.

Pie chart

The Excel feature that outlines all of the cells referenced in a formula.

Range finder

A command with which you can display text on multiple pages.

Text wrap

A chart line that contains numeric data.

Value axis