Exam 7: Specialized Functions

Database functions do not require a Criteria Range.

NPER calculates the periodic interest rate of an investment or loan.

An OR function evaluates to TRUE only if all of the conditions are true.

A(n)________ is a schedule that calculates the interest,principal repayment,and remaining balance of a loan.

________ can copy filtered information to a new location.

What effect does paying an extra small bit of principal on a mortgage have on the life of a 30 year loan?

The ________ function evaluates two or more conditions and returns true only if ALL conditions are met.

The Arguments of an INDEX function are array,row_num,and column_num.

An OR condition in an advanced filter requires at least two rows in the criteria range.

The ________ function identifies the highest value in a database column that matches specified conditions in a criteria range.

Why would you put a negative sign in many financial functions?

Which of the following are not arguments for the IPMT function?

Which function returns the relative position of a value?

The ________ function calculates the current value of an investment given a fixed discount rate.

The first argument of any database function is ________.

What is the purpose of the Row_num argument in the following INDEX function? =INDEX(A2: B5,MATCH(MAX(B2: B5),B2: B5,0),1)

This is a correct example of the structure of an IPMT function.=IPMT(rate,per,nper,pv,[fv],[type])

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

The PPMT function calculates the monthly principal and interest payment of a loan or investment.

The database argument of a database function must include the entire range of the database.