Financial =IPMT(rate, per, nper, pv, [fv], [type])

Quiz =IPMT — 10 Questions

10 quiz questions about =IPMT — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← IPMT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many optional arguments does =IPMT have?

Question 2 of 10 2/10

Which statement about =IPMT is correct?

Question 3 of 10 3/10

Is argument “nper” required in =IPMT?

Question 4 of 10 4/10

How many required arguments does =IPMT have?

Question 5 of 10 5/10

Which formula is a valid example of =IPMT?

Question 6 of 10 6/10

In =IPMT, which is argument #2?

Question 7 of 10 7/10

Which category does =IPMT belong to?

Question 8 of 10 8/10

What is the output type of =IPMT?

Question 9 of 10 9/10

What is the type of argument “nper” in =IPMT?

Question 10 of 10 10/10

What is the type of argument “rate” in =IPMT?

Click a question to see the answer.

1. How many optional arguments does =IPMT have?

A. 4
B. 1
C. 3
D. 2 ✓

Explanation: =IPMT has 4 required, 2 optional (6 total).

2. Which statement about =IPMT is correct?

A. Volatile and recalculates every time
B. Only works in old versions
C. Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at 12 percent annual interest, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12% for rate and 4 for nper. ✓
D. Select entire column for best performance

Explanation: Correct: Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at 12 percent annual interest, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12% for rate and 4 for nper.

3. Is argument “nper” required in =IPMT?

A. Yes
B. —
C. Yes ✓
D. No

Explanation: “nper” is required.

4. How many required arguments does =IPMT have?

A. 5
B. 4 ✓
C. 6
D. 3

Explanation: =IPMT has 4 required, 2 optional (6 total).

5. Which formula is a valid example of =IPMT?

A. =CUMIPMT(A2/12, A3, A4*12, A5)
B. =IPMT(A2/12, A3, A4*12, A5, 0)
C. IPMT(A2/12, A3, A4*12, A5)
D. =IPMT(A2/12, A3, A4*12, A5) ✓

Explanation: Correct example: =IPMT(A2/12, A3, A4*12, A5)

6. In =IPMT, which is argument #2?

A. per ✓
B. pv
C. rate
D. nper

Explanation: Argument #2 is “per”.

7. Which category does =IPMT belong to?

A. Cube
B. Compatibility
C. Financial ✓
D. Engineering

Explanation: Category is “Financial”.

8. What is the output type of =IPMT?

A. Text
B. Number ✓
C. Date
D. Value

Explanation: Output is “Number”.

9. What is the type of argument “nper” in =IPMT?

A. Date
B. Logical
C. Number ✓
D. Array

Explanation: Type of “nper” is “Number”.

10. What is the type of argument “rate” in =IPMT?

A. Value
B. Mixed
C. Text
D. Number ✓

Explanation: Type of “rate” is “Number”.