click below
click below
Normal Size Small Size show me how
spredsheets
| Question | Answer |
|---|---|
| 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 arranging text or numbers from a to z, from earliest to latest |
| autosum | a function that automatically adds the value in the calls 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 refernce | a unique identifier for a cell witch 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 bar of varying height to illustrate values in a worksheet |
| count | returns the number of cells in a range that contains number |
| descending | short order arranging text or numbers from z to a, largest to smallest 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 cells ot 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 rewritten formula that makes it easy to preform common clcuations |
| lablel | alphanumeric text that will not be used in calculations |