click below
click below
Normal Size Small Size show me how
CAII - Unit 2
CAII - Unit 2 Framework Words
| Term | Definition |
|---|---|
| Absolute Reference | Cell address that does not change when copied in a formula |
| Argument | Values or cell references (included between parentheses) that funciton 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 or 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 the column when the formula is copied |
| Order of Operation (math hierachy) | 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 |