# unit 3 terms pt1

## 19 terms

### Absolute cell reference

cell reference that does not adjust to the new cell location when copied or moved

### Active cell

a selected worksheet cell that is ready for data entry

### Alignment

the position of data within a cell

### Argument

value, cell reference, range, or text that acts as an operand in a function formula

### Ascending

sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest

### Autosum

a function that automatically adds the values in the cells directly above or to the left of the active cell

### AVERAGE

returns the average (arithmetic means) of its arguments

### Cell

the space formed by the intersection of a row and a column; the basic unit of a worksheet

### Cell reference

a unique identifier for a cell which is formed by combining the cell's column letter and row number

### Chart/Graph

a graphic representation of values and their relationships: pie, line, column, bar, scattered

### Column

a vertical group of cells in a worksheet identified by letters

### Column Chart

a chart that uses bars of varying height to illustrate values in a worksheet

### COUNT

returns the numner of cells in a range that contains numbers

### Descending

sort order arranging text or numbers form Z to A, largest to smallest, or latest to earliest

### Fill

to copy a cell's contents and/or formatting into an adjacent cell or range

### Format

arranging the shape, size, type, and general makeup of a cell or group of cells

### Formula

an equation that calculates a new value using values currently on a worksheet

### Freeze

keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls

### Function

a prewritten formula that makes it easy to perform common calculations