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 |