| A | B |
|---|
| Arguments | The values that an Excel function uses to perform calculations or operations. |
| Data Table | A range of cells that shows how changing certain values in your formulas affect the results of those formulas and that makes it easy to calculate multiple versions in one operation. |
| Data Validation | A technique by which you can control the type of data or the value that are entered into a cell by limiting the acceptable values to a defined list. |
| Defined Name | A word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value; also referred to as simply a name. |
| Financial Functions | Pre-built formulas that preform common business calculations such as calculating a loan payment on a vehicle or calculating how much to save each month to buy something; this commonly involves a period of time such as months or years. |
| Future Value (FV) | The value at the end of the time periods in an Excel function; the cash balance you want to attain after the last payment is made- usually zero for loans. |
| Goal Seek | One of Excel's What-If Analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell- find the right input when you know the result you want. |
| HLOOKUP | An Excel function that looks up values that are displayed horizontally in a row. |
| Interest | The amount charged for the use of borrowed money. |
| Lookup Functions | A group of Excel functions that look up a value in a defined range of cells located in another part of the workbook to find a corresponding value. |
| Name | A word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value; also referred to as a defined name. |
| Nper | The abbreviation for number of time periods in various Excel functions. |
| One-Variable Data Table | A data table that changes the value in only one cell. |
| PMT Function | An Excel function that calculates the payment for a loan based on constant payments and at a constant interest rate. |
| Present Value (PV) | The total amount that a series of future payments is worth now; also known as the principal. |
| Principal | Another term for present value. |
| Rate | In the Excel PMT function, the term used to indicate the interest rate for a loan. |
| Scope | The location within which a defined name is recognized without qualification- usually either to specific worksheet or to the entire workbook. |
| Table Array | A defined range of cells, arranged in a column or a row, used in VLOOKUP or HLOOKUP function. |
| Two-Variable Data Table | A data table that changes the values in two cells. |
| Type Argument | An optional argument in the PMT function that assumes that the payment will be made at the end of each time period. |
| Validation List | A list of values that are acceptable for a group of cells; only values on the list are valid and values not on the list are considered invalid. |
| VLOOKUP | An Excel function that looks up values taht are displayed vertically in a column. |
| What-If Analysis | The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet. |
| Auditing | The process of examining a worksheet for errors in formulas. |
| Circular reference | An Excel error that occurs when a formula directly or indirectly refers to itself. |
| Dependent cells | Cells that contain formulas that refer to other cells. |
| Error Checking command | A command that checks for common errors that occur in formulas. |
| Error value | The result of a formula that Excel cannot evaluate correctly. |
| Formula | An equation that performs mathematical calculations on values in a worksheet. |
| Formula Auditing | Tools and commands accessible from the Formulas tab that help you check your worksheet for errors. |
| Iterative calculation | When Excel recalculates a formula over and over because of a circular reference. |
| LOOKUP | An Excel function that looks up values in either a one-row or one-column range. |
| Precedent cells | Cells that are referred to by a formula in another cell. |
| Trace Dependents command | A command that displays arrows that indicate what cells are affected by the value of the currently selected cell. |
| Trace Error command | A tool that helps locate and resolve an error by tracing the selected error value. |
| Trace Precedents command | A command that displays arrows to indicate what cells affect the value of the cell that is selected. |
| Tracer arrow | An indicator that shows the relationship between the active cell and its related cell. |
| Watch Window | A window that displays the results of specified cells. |
