| AB ArgumentsThe values that an Excel function uses to perform calculations or operations. Data TableA 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 ValidationA 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 NameA 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 FunctionsPre-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 SeekOne 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. HLOOKUPAn Excel function that looks up values that are displayed horizontally in a row. InterestThe amount charged for the use of borrowed money. Lookup FunctionsA 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. NameA 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. NperThe abbreviation for number of time periods in various Excel functions. One-Variable Data TableA data table that changes the value in only one cell. PMT FunctionAn 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. PrincipalAnother term for present value. RateIn the Excel PMT function, the term used to indicate the interest rate for a loan. ScopeThe location within which a defined name is recognized without qualification- usually either to specific worksheet or to the entire workbook. Table ArrayA defined range of cells, arranged in a column or a row, used in VLOOKUP or HLOOKUP function. Two-Variable Data TableA data table that changes the values in two cells. Type ArgumentAn optional argument in the PMT function that assumes that the payment will be made at the end of each time period. Validation ListA 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. VLOOKUPAn Excel function that looks up values taht are displayed vertically in a column. What-If AnalysisThe process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet. AuditingThe process of examining a worksheet for errors in formulas. Circular referenceAn Excel error that occurs when a formula directly or indirectly refers to itself. Dependent cellsCells that contain formulas that refer to other cells. Error Checking commandA command that checks for common errors that occur in formulas. Error valueThe result of a formula that Excel cannot evaluate correctly. FormulaAn equation that performs mathematical calculations on values in a worksheet. Formula AuditingTools and commands accessible from the Formulas tab that help you check your worksheet for errors. Iterative calculationWhen Excel recalculates a formula over and over because of a circular reference. LOOKUPAn Excel function that looks up values in either a one-row or one-column range. Precedent cellsCells that are referred to by a formula in another cell. Trace Dependents commandA command that displays arrows that indicate what cells are affected by the value of the currently selected cell. Trace Error commandA tool that helps locate and resolve an error by tracing the selected error value. Trace Precedents commandA command that displays arrows to indicate what cells affect the value of the cell that is selected. Tracer arrowAn indicator that shows the relationship between the active cell and its related cell. Watch WindowA window that displays the results of specified cells. Show Is the process of examining a worksheet for errors in formulas?The process of examining a worksheet for errors is referred to as auditing. Excel identifies errors in several ways. The first way is to display an error code in the cell that contains the formula generating the error. When the active cell generates an error, Excel displays an Error button next to it.
What indicates which cells are affected by the value of a selected cell?Trace Dependents command. A command that displays arrows that indicate what cells are affected by the value of the currently selected cell.
Which of the following functions adds all the values and divides the result by the number of values?AVERAGE function
An Excel function that adds a group of values and then divides the result by the number of values in the group.
Which WhatGoal Seek is a What-If Analysis tool that helps you to find the input value that results in a target value that you want. Goal Seek requires a formula that uses the input value to give the result in the target value. Then, by varying the formula's input value, Goal Seek tries to solve the input value.
|
