Exam 24: Excel: Specialized Functions

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.

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

When using Advanced Filtering < > is the equivalent of:

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

Which database function will return the largest value from a dataset based on preset criteria?

The FV function is best suited for calculating the current value of an investment.

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

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

The ________ should be used to calculate the periodic rate of a loan given the NPER,PMT,and PV.

Which of the following functions should be used to evaluate multiple conditions with only two possible outcomes?

The ________ function is best suited when two or more logical tests are required and at least one condition must be true to return the value_if_true.

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

Which of the following is not an argument in a database function?

=IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9))is an example of a(n):

The end_period argument should have the value of ________ if you are calculating cumulative interest using CUMIPMT for the third payment of a loan.

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

Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years?

When using Advanced Filtering,the criteria range must contain at least: