How can we help?

You can also find more resources in our Help Center.

31 terms

Absolute cell reference

Does not change when copied or moved to a new cell

Argument

The value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand

Cell reference

Identifies the cell, and is formed by combining the cell's column letter and row number

Cell

The intersection of a row and a column

Chart area

The entire chart and all other chart elements

Chart sheet

A separate sheet in the workbook that stores a chart

Chart

A graphical representation of data

Column

Appears vertically and is identified by letters at the top of the worksheet window

Data label

Text or numbers that provide additional information about a data marker

Data source

Chart data

Data table

A grid that displays the data plotted in the chart

Embedded chart

After you select a chart type and style, the chart is inserted as an embedded chart in the center of the worksheet

Fill handle

Appears in the lower-right corner of the active cell or range, and is used to fill cells

Fill

Copies a cells contents and/or formatting into an adjacent cell or range

Formula Bar

Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value

Formula

An equation that calculates a new value from values currently in a worksheet

Formula

The equation used to calculate values in a cell

Label

a text entry such as a heading used to identify a column of data.

Legend

A list that identifies patterns, symbols, or colors used in a chart

Mixed cell reference

Cell references that contain both relative and absolute references

Order of evaluation

The sequence used to calculate the value of a formula

Range reference

How the range is identified; made up of the cell in its upper-left corner and the cell in its lower-left corner, separated by a colon

Range

A group of selected cells

Relative cell reference

Adjusts to its new location when copied or moved

Row

Appears horizontally and is identified by numbers on the left side of the worksheet window

Spreadsheet

A grid of rows and columns in which you enter text, numbers, and the results of calculations

Value

Any input in a cell that can be used in mathematical equations (numbers and formulas)

Workbook

The file used to store worksheets

Worksheet range

A group of adjacent worksheets

Worksheet

A computerized spreadsheet

3-D Cell Reference

A reference to the same cell or range in multiple worksheets that you use in a formula