Exam 6: Excel : Formulas and Functions

What type of cell reference should be used when a value remains constant?

Match the following terms with their description: I. Median II. Average III. Sum IV. Table array V. Breakpoint A. Total B. Lowest value in a series C. Midpoint value D. Range used for looking up values E. Arithmetic mean

What is not a direct option on the AutoSum drop down menu?

If you will never copy and paste a formula you do not have to be concerned about absolute, relative, or mixed references.

Which of the following would not produce the correct monthly payment on a loan of $13,000 which will be paid off in 5 years with an annual interest rate of 6%?

Excel assigns date number 1 to January 1, 1900.

Which status bar statistic can you not enable?

This is not a valid way to use the MAX function: =MAX(a4:d11, f1:f2)

If a cell containing =B$14 is copy and pasted three columns over and two rows down, what would the resultant cell reference become?

It is very important to sort the first column in a table lookup array in descending order.

If the annual interest rate is 12% and payments are made monthly, then you would enter ________ in the RATE argument in the PMT function.

Which of the following will not return the system clock's date?

The ________ function counts the number of calculable values, but ignores cells that have text or are empty.

The inputs in a function are specified by its ________.

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

How many functions does Excel provide?

Which function would you use to find the oldest date in a range?

The test in an IF function must evaluate to either a True or a False.

What keyboard shortcut will automatically update any formulas using =TODAY()or =NOW()?

All IF functions have three arguments.