click below
click below
Normal Size Small Size show me how
Spreadsheet Terms
| 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. |