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

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

Question 2 of 10 2/10

Which function is NOT related to =IPMT?

Question 3 of 10 3/10

Since which Excel version is =IPMT available?

Question 4 of 10 4/10

Which statement about =IPMT is correct?

Question 5 of 10 5/10

In =IPMT, which is argument #2?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Is argument “fv” required in =IPMT?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which formula is a valid example of =IPMT?

Question 10 of 10 10/10

Which category does =IPMT belong to?

Click a question to see the answer.

1. What is the type of argument “pv” in =IPMT?

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

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

2. Which function is NOT related to =IPMT?

A. ISPMT
B. PMT
C. DURATION ✓
D. CUMIPMT

Explanation: “DURATION” is not related to IPMT.

3. Since which Excel version is =IPMT available?

A. All versions ✓
B. Excel 2019
C. Excel 365
D. Excel 2007 (Compatibility)

Explanation: Version: “All versions”.

4. Which statement about =IPMT is correct?

A. For all the arguments, cash you pay out, such as deposits to savings, is represented by negative numbers. Cash you receive, such as dividend checks, is represented by positive numbers.
B. Text is always ignored
C. Only works in old versions
D. 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. ✓

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.

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

A. value
B. criteria
C. range
D. per ✓

Explanation: Argument #2 is “per”.

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

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

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

7. Is argument “fv” required in =IPMT?

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

Explanation: “fv” is optional.

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

A. Reference
B. Number ✓
C. Date
D. Mixed

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

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

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

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

10. Which category does =IPMT belong to?

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

Explanation: Category is “Financial”.