| A | B |
|---|
| Operators are not found in __. | Function Formulas |
| AutoSum button creates the function formula =___ in the highlighted cell. | SUM |
| This function formula displays the smallest number contained in a range identified in the argument. | MIN |
| Function Arguments can be entered by__. | typing the argument in the cell or using the Insert Function dialog box. |
| What function will insert the current date or time in a cell. | NOW() |
| What is enclosed in parentheses in a function formula? | Arguments |
| What function formula is inserted in a cell when you click the AutoSum button? | SUM |
| What dialog box specifies elements to be included in the function formula? | Insert Function |
| What function performs various operations, such as finding the present and future vales? | Financial |
| What function describes large quantities of data, such as average, standard deviation, or variance of a range of data? | Statistical |
| Determine the smallest value in A4:A90. | =MIN(A4:A90) |
| Determines the standard deviation of the values in K6:K35. | =STDEV(K6:K35) |
| Determines the average of values in B9:B45. | =AVERAGE(B9:B45) |
| Determine the yearly payments on a $5,000 loan at 8% for 10 years. | =PMT(.08,10,5000) |
| Determine the value of a savings account at the end of 5 years after making $400.00 yearly payment; the account earns 8% | =FV(.08,5,400) |
| Round the value in C3 to the tenths place. | =ROUND(C3,1) |
| Determine the present value of a pension plan that will pay you 20 yearly payments of $4,000; the current rate of return in 7.5%. | =PV(.075,20,4000) |
| Determine the square root of 225. | =SQRT(225) |
| Determine the variance of the values in F9:F35 | =VAR(F9:F35) |
| Add all the values in D4:D19. | =SUM(D4:D19) |
| Determine how many cells in H7:H21 are filled with data. | =COUNT(H7:H21) |
| Determine the largest value in E45:E92 | =MAX(E45:E92 |
