Exam 21: Specialized Functions

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

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

Which database function should be used to count records with empty cells?

=INDEX(A2: B5,MATCH(MAX(B2: B5),B2: B5,0),1)is an example of a nested function.

The MATCH function match_type must be set to 0 when matching words.

In the function =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)),F5*K7 is the:

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

If payments are made at the beginning of the month the type argument should be set to ________ when using the IPMT function

Excel permits ________ IF statements in one formula.

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

The first argument of any database function is ________.

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

Which of the following functions will return the principal payment of a loan?

Which of the following functions requires all arguments to be true in order to return the value if true?

Which function will calculate the current value on an investment that will earn 5% interest on yearly payments of $100 over 10 years?

If payments are made at the end of the month the type argument should be set to ________ when using the IPMT function

________ can copy filtered information to a new location.

The ________ function determines the arithmetic mean,or average,of numeric entries in a database column.