click below
click below
Normal Size Small Size show me how
Unit 2 Spreadsheets
Using Functions and Formulas, and Constructing Templates
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 the 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 |