click below
click below
Normal Size Small Size show me how
CA II - Unit 2
Computer Applications II Unit 2 Spreadsheet Review II
| Question | Answer |
|---|---|
| Cell address that does not change when copied in a formula. | absolute reference |
| Values or cell references (included between parentheses) that a function needs to complete its calculation. | argument |
| Built-in mathematical function that determines the average of a block of cells. | average function |
| A feature that allows the user to copy of fill data in cells adjacent to the original cell. | fill |
| A method of keeping certain rows of columns visible at all times (such as headings or certain lables). | freeze title |
| Built-in mathematical function. | function |
| Function that returns the highest number in a range of cells. | max function |
| Returns the lowest number in a range. | min function |
| Cell address that adjusts either the row or the column when the formula is copied. | mixed reference |
| Alternative term for order of precedence or math hierarchy. | order of operation |
| Cell address that adjusts to the row or column where a copied formula is located. | relative reference |
| Projecting with a spreadsheet by changing the data. | what-if analysis |