click below
click below
Normal Size Small Size show me how
CBA Unit 3 Part 1
First 1/2 of Vocabulary Terms and Definitions for Arkansas CBA Unit 3
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 |
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 |
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 number of cells in a range that contains numbers – returns the number of cells in a range that contains numbers |
Descending | sort order arranging text or numbers from 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 |