Exam 7: Specialized Functions

If you have 3 possible outcomes in a nested IF statement, then you need ________ logical tests.

The ________ function returns the position of a value.

The ________ function returns the difference between 2 dates.

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

________ can copy filtered information to a new location.

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

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

The formula = ________ (10/15/2018,2)would return 12/15/2018.

4)If there are 5 possible outcomes, how many logical tests are required?

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

What is the first argument of an IF function?

The ________ function calculates the periodic interest for a specified payment period on a loan or investment.

You need the same number of logical tests as outcomes in a nested IF function.

Which of these is not a capability of the Advanced Filter tool?

IF you use the function, =MATCH(66, A1:A4,0), on the table below, what would be the result?

Which function calculates a periodic rate for an investment or loan given the number of payments, fixed periodic payments, and present value?

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

If your database field contains empty cells, you should use the ________ function to count it.

What is the match_type argument value for an exact match in a MATCH function?