Exam 2: Formulas and Functions

The ________ is the lowest value for a category in the table lookup table.

Which keyboard shortcut toggles through the types of reference options?

The range that contains the lookup table is called the ________.

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

If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?

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

If a cell contains =$N$21 and two new columns are inserted in front of column N and three rows are inserted above row 21,what happens to the =$N$21?

Which of the following is not a category of functions?

________ references change when formulas are copy and pasted.

The COUNTBLANK function will count cells that contain formulas that compute to a value of zero (0).

If you omit the fourth argument in a VLOOKUP function,Excel will assume you intend the fourth argument to be False.

The inputs in a function are specified by its ________.

The HLOOKUP function can only be used to find exact matches.

You could use both A3>b9 or B9<A3 as the test in an IF function and get the same results.You would just switch the second and third arguments.

When entering functions,the square brackets,[],indicate required values.

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