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 |