Exam 7: Specialized Functions

An empty cell in the criteria in an Advanced Filter will display no records.

A loan amortization table is a schedule that calculates the interest per payment period,principal repayment for each payment,and remaining balance after each payment is made.

When using advanced filtering,leaving a cell empty in the criteria range will return which of the following?

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

What is the purpose of an Excel What-if scenario?

Which financial function calculates the net present value of an investment,given a fixed discount rate?

The YEARFRAC function returns the number of the month in a year.

The ________ function returns the position of a value.

If 9/3/2021 is the contents of B3,what would be the result of =MONTH(B3)?

When formated as a date,the results of EDATE(Start_Date,3)if the contents of Start_Date is 10/30/2018 would be ________.

You can nest AND,OR and NOT functions in an IF function.

Which function calculates the Reduction in C2 to be filled through the rest of the reduction column if silver members have a 5% discount,gold 10% and Platinum have 20%?

A NOT function reverses the truth of a logical test.

A(n)________is a matrix that provides the results (TRUE or FALSE)for every possibility of an AND,OR,or NOT criteria combination.

The EOMONTH function returns the last day of the month of the specified number of months from a given date.

What type of match would the following function return when the lookup array is sorted in descending order? =MATCH(A3,B7: B53,-1)

A(n)________ is a schedule that calculates the interest per payment period,principal,repayment,and remaining balance.

The YEARFRAC calculates ________.