AIVPMT()
BIVSTPMT()
CISTPMT()
DISPMT()
Answer:
D. ISPMT()
Read Explanation:
Functions in Excel
- Function in Excel includes Mathematical functions, Statistical functions , Text functions, Logical functions
- Statistical function in Excel
Average() , Count() , Max() , Min(), Stdev() , Var().
- Mathematical functions
Abs() , Int() , Mod() , Rand() , Sqrt() , Sum()
Examples of functions
Functions Example Description
Sum =SUM(A1:A10) Finds sum of cells A1 through A10
Average =AVERAGE(A1:A10) Finds average of the cells A1 through A10
Max =MAX(C1:C50) Finds the highest of the values from C1 to C50
Min =MIN(C1:C50) Finds the lowest number from the cells C1 to C50
- Text functions
Char() , Concatenate() , Len()
- Logical functions
And() , Or() , IF() , NOT()
- Financial functions
Rate() , FV() , PV() , NPV() , PMT() , IRR()
- Function to add all the numbers in a range of Cells
SUM()
- Function which calculates the average of its numbers
AVERAGE()
- Function to check whether a condition is met IF( it returns a value if TRUE and another value if FALSE)
- Function to create a shortcut to open a stored document in hard disk or network server
Hyper link
- Function to count the number of cells that contain numbers and numbers within the list of arguments : count
- Function which returns the largest value in a set of values : MAX()
- Function which calculates the payment for a loan based on constant payments and a constant interest rate : PMT()
- Function which returns the interest paid during a specific period of an investment : ISPMT()
- Function to calculate the periodic rate of interest for an investment over a specific period
Rate()
- Function to calculate the future value for a series of equal investments, earning a fixed periodic rate of interest : FV ()
- Function to calculate the net present value of a series of future cash flows discounted a fixed interest rate : NPV()