Exam 21: Specialized Functions

Advanced filtering will not copy results to a new location.

What is the difference between advanced filtering and database functions?

All database functions require a user defined:

________ calculates the standard deviation of a sample population.

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

________ is the best database function for counting data that contains empty cells.

Which of the following is the best choice to lookup values when VLOOKUP and HLOOKUP are not possible?

The ________ function should be used to calculate the interest paid on the first payment of a mortgage.

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

Which function will calculate the periodic interest rate of a loan with a $500 payment on a $20000 loan paid back over 5 years?

________ will return the total interest paid within a time range on a loan.

The ________ function returns a user defined message if an error is detected.

In order for the OR function to return a true value,one or more arguments must be true.

CUMPRINC contains six arguments.

The ________ function returns the position of a value in a list.

The PV function would be best suited to calculate the future value of an investment.

What is the purpose of an amortization table?

When the DAVERAGE function returns #DIV/0:

If a nested IF statement has 6 possible outcomes it requires ________ logical tests.