Exam 24: Excel: Specialized Functions

In order for the NOT function to return a true value,all arguments must be false.

The ________ function should be used to calculate the total number of periods in a loan.

All database functions require a user defined:

A PMT of zero can be used in the FV function.

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

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

CUMIPMT calculates the cumulative interest throughout a loan.

What is the difference between advanced filtering and database functions?

To perform an advanced filter with an OR condition you must select at least two rows of the criteria range.

The MATCH function can be used to match words.

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

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

Which of the following functions returns the position of a value in a list?

Excel permits ________ IF statements in one formula.

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

The ________ function will only trigger the value_if_true if all conditions given are false.

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

CUMPRINC contains six arguments.

________ will return the principal paid on one specific payment of a loan.