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 |