Exam 7: Excell: Formulas and Functions

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

The VLOOKUP function has four required arguments.

In the HLOOKUP function, the third argument is the column index number.

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

The ________ function actually changes the number of decimal places in the value.

What describes a function's purpose?

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

Which of the following is not a valid test in an =IF statement?

What error will you get if you type a function name incorrectly?

Match the following terms with their description: i. NOW() II. TODAY() III. PV IV. RATE v. PMT

The most used logical function is the IF function.

Functions can be nested inside the arguments in the various lookup functions.

The COUNTA function only counts text entries. It does not count calculable values or blank cells.