Chapter 7 - Specialized Functions

Question 1

Calculates the number of periods for an investment or loan given a fixed rate, period payment and present value.

Answer 1

NPER Function

Question 2

Calculates the future valueof an investment given fixed rate, a term and identical periodic payments.

Answer 2

FV Function

Question 3

Calculates the Net Present Value of an investment with fixed rate and periodic payment that maybe identical or different.

Answer 3

NVP Function

Question 4

Calculates cumulative principal for a speicified payment period.

Answer 4

CUMPRINC Function

Question 5

Calculates the Present Value of an investment with fixed rate, specified number of periods, and identical periodic payments that will be made in the future.

Answer 5

PV Function

Question 6

Calculates the cumulative interest for a specified payment period

Answer 6

CUMPMNT Function

Question 7

A schedule showing monthly payments, interest payment, amount toward paying off the loan, and remaining balance for each payment.

Answer 7

Loan Amortization Table

Question 8

Calculates the principal payment for a specified payment period on a loan or an investment given a fixed rate, spexified term and identical periodic payment.

Answer 8

PPMT Function

Question 9

Calculates the periodic interest for a specified payment period on a loan or an investment given a fixed rate, spexified term and identical periodic payment.

Answer 9

IPMT Function

Question 10

Returns the average of all cells that meet multiple criteria

Answer 10

AVERAGEIFS Function

Question 11

A type of chart that displays a **visual representation of geographic region to illustrate relative values

Answer 11

Map Charts

Question 12

Returns the number representing the day of the week where 1 represent Sunday and **7 represents Saturday **by default.

Answer 12

WEEKDAY Function

Question 13

Calculates the** total of a range of values** when a specified condition is met.

Answer 13

SUMIF Function

Question 14

A logical function that evaluates multiple conditions and returns a result that correspond with the first true conditon.

Answer 14

IFS Function

Question 15

Calculates the fraction of a year between two dates based on teh number of whole days.

Answer 15

YEARFRAC Function

Question 16

Returns the number of cells that meet a condition.

Answer 16

COUNTIF Function

Question 17

Calculates the total of a** range of values **when multiple conditions are met.

Answer 17

SUMIFS Function

Question 18

Extracts the year from a date

Answer 18

YEAR Function

Question 19

Returns TRUE if **any argument is true and returns FALSE if all arguments are false.

Answer 19

OR Function

Question 20

Rerturns TRUE when** all arguments** are true and FALSE when at least one argument is false.

Answer 20

AND Function