click below
click below
Normal Size Small Size show me how
Modified Unit 3 CBA
Modified Flash Cards for the CBA Unit 3 Test
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 |
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 |
Column | a vertical group of cells in a worksheet identified by letters |
Fill | to copy a cell's contents and/or formatting into an adjacent cell or range |
Formula | an equation that calculates a new value using values currently on a worksheet |
Function | a prewritten formula that makes it easy to perform common calculations |
Line chart | a chart that uses points connected by a line to illustrate values in a worksheet |
Operand | a number or cell reference used in a formula |
Operator | a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide ( |
Order of operation | the mathematical rules used for calculating the value of a formula |
Pie chart | a chart that shows the relationship of a part to a whole |
Range | selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon |
Row | a horizontal group of cells in a worksheet identified by numbers |
Spreadsheet | a grid of rows and columns containing numbers, text, and formulas used to perform calculations |
SUM | adds all the numbers in a range of cells |