| A | B |
|---|
| You must enter this character as the first character in a function formula so that Excel will recognize it as a formula. | = |
| This function is used to round up the values in a selected range (note: it does not sum the selected range). | ROUND |
| To calculate the standard deviation of the number contained in the range of the argument, you would use this function. | STDEV (standard deviation) |
| You would use this function to calculate the payment for a loan based on constant payments and a constant interest rate. | PMT (payment) |
| You can use this function to display dates in many different formats. | DATE |
| Logical functions may be used to display these if certain conditions exist. | Text or values |
| These are special formulas that do not use operators to calculate a result. | Function formulas |
| This function determines the payment needed each period to repay a loan. | PMT (payment) |
| This function determines the current value of an investment that will return a series of equal payments in the future. | PV (present value) |
| This function will display today's date in a worksheet. | NOW |
| This functions will display the current time in a worksheet. | NOW |
| What is the purpose of the COUNT function? | It determines the number of filled cells in a range. |
| The following are parts of a function formula. | The equal sign, the function name, and the argument |
| This function shows the square root of the number identified in the argument. | SQRT |
| This function displays the number of cells with numerical values in the argument range. | COUNT |
| This function displays the future value of a series of equal payments. | FV (future value) |
| This function displays the date or time based on the computer’s clock. | NOW |
| This function displays the largest value in a selected range of cells. | MAX |
| This function displays the smallest value in a selected range of cells. | MIN |
| This function displays the average value in a selected range of cells. | AVERAGE |
| This function adds the total value of a selected range of cells. | SUM |
