Term | Definition |
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. |
Arguement | Value, cell reference, range, or text that acts as an operand in a function formula |
Ascending | Sort order arranging text or numbers form A to Z, from smallest to largest, or from earliest to latest. |
Autosum | A function that automatically adds the values in the cell 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, Column, Bar, Scattered |
Column | Vertical group of cells in a worksheet identified by letters |
Column Chart | Chart that uses bars of varying height to illustrate values |
COUNT | Returns the number of cells in a worksheet identified by letters. |
Descending | Sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest. |
Fill | 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 | 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 | Prewritten formula that makes it easy to preform common calculations. |
Label | Alphanumeric text that will not be used in calculations. |
Line Chart | Chart that uses points connected by a line to illustrate values in a worksheet. |
MAX | Returns the largest value in a set of values. |
MIN | Returns the smallest values in a set of values. |
Mixed Cell Reference | Cell reference that contains both relative and absolute references. |
Operand | Number or cell reference used in a formula. |