Exam 2: Formulas and Functions

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell.

The ________ function finds the smallest value in a range.

What does Excel use to indicate optional arguments in a function?

FV is a required argument in the PMT function.

A lookup table should contain at least two rows and two columns, not counting headings.

The PMT function uses three required arguments and no optional arguments.

Where does Excel automatically display statistics like count, average, and sum when a range of values is selected?

Which of the following is not a valid lookup function?

To look up an exact match, what should you enter in the range_lookup argument?

There are rare occasions when both the second and third argument of an IF function are executed.

The ________ feature in Excel displays various options when you type an equal (=)sign and then begin typing a function name.

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

The TODAY()and NOW()functions are updated every time you open or ________ the spreadsheet.

If you wanted to count the number of entries in a list that contained numbers, text, and blank cells, but ignore the blank cells, which function would you use?

A function's ________ defines the rules by which the function operates.

What punctuation is used to separate the two cell references in a range?

The VLOOKUP function has four required arguments.

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

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