Exam 21: Specialized Functions

Returns the value or the reference to a value within a range based on X and Y coordinates.

The MATCH type should be set to ________ when matching words with the MATCH function.

If there are four possible outcomes,how many logical tests are required?

The IPMT function should be used to calculate the specific interest paid on one installment of a loan.

The MATCH function will return a value of 1 if the given lookup_value is the largest number in an array of numbers.

What is the benefit of using MATCH nested with INDEX over lookup functions such as VLOOKUP?

The first argument of the INDEX function is:

CUMIPMT calculates the cumulative interest throughout a loan.

What is the maximum number of IF statements in a formula?

The ________ function is best suited when two or more logical tests are required and all conditions must be true in order to return the value_if_true.

Which of the following functions will calculate the total interest paid between select periods?

The ________ function is best suited to return the highest numerical value of a range of values within a database.

In the FV function,the rate argument refers to the:

Which function will return the intersection of a specific row and column?

Which of the following functions returns a value or the reference to a value within a range based on X And Y coordinates?

What is the first argument of the IF function?

When using the MATCH function with an exact match lookup_value,the match type must be set to:

The maximum number of IF statements in one formula is 64.