click below
click below
Normal Size Small Size show me how
CA 2 Unit 2
Ca 2 Unit 2
Term | Definition |
---|---|
Absolute Reference | Cell address that does not change when copied in a formula |
Argument | Values or cell references (included between parentheses) that a function needs to complete its calculation |
Average Function | Built-in mathematical function that determines the average of a block of cells |
Fill | A feature that allows the user to copy of fill data in cells adjacent to the original cell |
Freeze Title | A method of keeping certain rows of columns visible at all times (such as headings or certain labels) |
Function | Built-in mathematical formula |
Max Function | Function that returns the highest number in a range of cells |
Min Function | Returns the lowest number in a range |
Mixed Reference | Cell address that adjusts either the row or column when the formula is copied |
Order of Operation (Math hierarchy) | Alternative term for order of precedence |
Relative Reference | Cell address that adjusts to the row or column where a copied formula is located |
What-if Analysis | Projecting with a spreadsheet by changing the data |