Exam 24: Excel: Specialized Functions

The maximum number of IF statements in one formula is 64.

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

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

Which of the following is a nested function?

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

Which function will return the intersection of a specific row and column?

Which of the following database functions is best suited to add total salaries from a database that are higher than $30,000?

The RATE function returns the periodic rate for an investment or loan.

Which of the following functions does not support multiple conditions?

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

________ can copy filtered information to a new location.

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

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

________ will return the interest paid for one installment of a loan.

When the DAVERAGE function returns #DIV/0:

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

What is the second argument of the IF function?

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

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