click below
click below
Normal Size Small Size show me how
Spreadsheets Un 2
Unit 2 Vocabulary
Question | Answer |
---|---|
Absolute reference | – Cell reference that points to a specific cell and does not change when copied, appears with a dollar sign ($) before each column and row designation |
IF function | A lgical function that returns one value if the statement is true and another value if the statement is false |
Logical function | A category of functions that tests, or evaluates, whether a condition, usually entered as an expression, is true or false |
Mixed reference | Cell reference that contains both relative and absolute references |
INT function | The financial function to calculate the amount paid into an investment or loan during each payment period |
Relative reference | In a formula, the address of a cell range based on the relative position of the cell that contains the formula and the cell the formula refers to.If you copy the formula, the relative reference is adjusted to reflect the new location. |
AutoFill | A tool that enables you to copy the contents of the selected cells by dragging the fill handle over another adjacent cell or range of cells rather than using the Copy and Paste commands |