# Excel

### 31 terms by JASpann

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

Excel terms to practice as you work through the Excel Unit.

### 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

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

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

### 3-D Cell Reference

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

Example: