click below
click below
Normal Size Small Size show me how
Chapter 6 - Excel
Term | Definition |
---|---|
Absolute Cell Reference | A cell reference that does not change when copied because a dollar sign has been placed in front of both the column letter and row number, such as $A$5. |
Alphabetical order | See Ascending order. |
Amortization | A method for computing equal periodic payments for an installment loan. |
Amortization table | Displays the interest and principal amounts for each payment of an installment loan. |
Arguments | The data required by a function. |
Ascending order | In order from lowest to highest. Also called alphabetical order when the data is text and chronological order when the data is times or dates. |
AVERAGE | Function that adds the values in a range of cells and then divides the result by the number of cells in the range. |
Chronological | See Ascending order. |
Descending | In order from highest to lowest. |
Destination | The upper-left cell of the range where data is to be pasted when copying or moving data between sheets. |
Function | Performs a calculation that results in a single value. |
IF function | Function that is used to make a decision based on a comparison. |
Installment loan | Loan that is repaid in a series of periodic payments. |
Key sort column | The column that contains the values that a sort is based on. |
Linked cells | Data that is connected to the source cell and will automatically update if the source cell is changed. |
MAX | Function that displays the largest value in a range of cells. |
MIN Function that displays the smallest value in a range of cells. | |
PMT | Function that calculates the periodic payment for an installment loan. |
Principal | The amount of money owed on a loan. |
Relational operators | Used to compare two values. Operators include =, <, >, <=, >=, <>. |
ROUND function | Changes a value by rounding it to a specific number of decimal places. |
Sorting | Arranging data in a specified order. |
Source | The cell or range of data to be copied when copying or moving data between sheets. |
Spreadsheet model | A worksheet containing data relating to a particular situation. |
Static | Copied data that is not connected to the source data. |
SUM | Function that adds the values in a range of cells. |
Syntax | The expected form or structure of a function. |
What-if analysis | The process of making decisions using a spreadsheet model. |
What-if question | A question that is answered using a worksheet model. |