Exam 7: Specialized Functions

Which function calculates the total principal through a specified number of payments?

The ________ function calculates the cumulative interest through a specified number of payments.

Advanced filtering will not copy results to a new location.

What function returns the total present value of an investment with a fixed rate,specified number of payment periods and a series of identical future payments?

Which function calculates the total amount of interest paid over a specific number of payments?

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

Which of these functions does not support multiple conditions?

In database functions,<>,>,=,<,>= and <= are called ________.

You need to know how many clients you have in a dataset with these fields in these ranges.Criteria are in A363: F365. Which function would accomplish this task?

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

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

A(n)________ is a group of two or more adjacent cells that specifies the conditions used to control the results of a filter.

A MATCH function returns the value of a given position.

Which function returns a value at the intersection of a specified row and column?

The ________ function returns the difference between 2 dates.

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