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

Quiz =PMT — 10 Questions

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

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

← PMT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which formula is a valid example of =PMT?

Question 2 of 10 2/10

Is argument “fv” required in =PMT?

Question 3 of 10 3/10

Which statement about =PMT is correct?

Question 4 of 10 4/10

Since which Excel version is =PMT available?

Question 5 of 10 5/10

How many optional arguments does =PMT have?

Question 6 of 10 6/10

Is argument “pv” required in =PMT?

Question 7 of 10 7/10

Which function is related to =PMT?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Is argument “type” required in =PMT?

Question 10 of 10 10/10

Which function is NOT related to =PMT?

Click a question to see the answer.

1. Which formula is a valid example of =PMT?

A. PMT(A2/12,A3,A4)
B. =PMT(A2/12,A3,A4, 0)
C. =EDATE(A2/12,A3,A4)
D. =PMT(A2/12,A3,A4) ✓

Explanation: Correct example: =PMT(A2/12,A3,A4)

2. Is argument “fv” required in =PMT?

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

Explanation: “fv” is optional.

3. Which statement about =PMT is correct?

A. Select entire column for best performance
B. The payment returned by PMT includes principal and interest but no taxes, reserve payments, or fees sometimes associated with loans. ✓
C. Text is always ignored
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 an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12 percent for rate and 4 for nper.

Explanation: Correct: The payment returned by PMT includes principal and interest but no taxes, reserve payments, or fees sometimes associated with loans.

4. Since which Excel version is =PMT available?

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

Explanation: Version: “All versions”.

5. How many optional arguments does =PMT have?

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

Explanation: =PMT has 3 required, 2 optional (5 total).

6. Is argument “pv” required in =PMT?

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

Explanation: “pv” is required.

7. Which function is related to =PMT?

A. EDATE ✓
B. F.TEST
C. IMPORTTEXT
D. SKEW.P

Explanation: “EDATE” is related to PMT.

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

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

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

9. Is argument “type” required in =PMT?

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

Explanation: “type” is optional.

10. Which function is NOT related to =PMT?

A. ROUND
B. EDATE
C. COUNTBLANK ✓
D. FV

Explanation: “COUNTBLANK” is not related to PMT.