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

Quiz =PPMT — 15 Questions

15 quiz questions about =PPMT — test syntax, arguments, examples & errors!

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

← PPMT ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

In =PPMT, which is argument #3?

Question 2 of 15 2/15

How many required arguments does =PPMT have?

Question 3 of 15 3/15

In =PPMT, which is argument #2?

Question 4 of 15 4/15

Since which Excel version is =PPMT available?

Question 5 of 15 5/15

Is argument “rate” required in =PPMT?

Question 6 of 15 6/15

Which function is NOT related to =PPMT?

Question 7 of 15 7/15

Which statement about =PPMT is correct?

Question 8 of 15 8/15

Is argument “per” required in =PPMT?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

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

Question 11 of 15 11/15

What is the type of argument “per” in =PPMT?

Question 12 of 15 12/15

Is argument “fv” required in =PPMT?

Question 13 of 15 13/15

What is the type of argument “fv” in =PPMT?

Question 14 of 15 14/15

Is =PPMT volatile?

Question 15 of 15 15/15

Is argument “type” required in =PPMT?

Click a question to see the answer.

1. In =PPMT, which is argument #3?

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

Explanation: Argument #3 is “nper”.

2. How many required arguments does =PPMT have?

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

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

3. In =PPMT, which is argument #2?

A. per ✓
B. nper
C. type
D. range

Explanation: Argument #2 is “per”.

4. Since which Excel version is =PPMT available?

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

Explanation: Version: “All versions”.

5. Is argument “rate” required in =PPMT?

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

Explanation: “rate” is required.

6. Which function is NOT related to =PPMT?

A. IPMT
B. PMT
C. CUMPRINC
D. DSTDEV ✓

Explanation: “DSTDEV” is not related to PPMT.

7. Which statement about =PPMT is correct?

A. Text is always ignored
B. Select entire column for best performance
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. Only works in old versions

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.

8. Is argument “per” required in =PPMT?

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

Explanation: “per” is required.

9. What is the type of argument “pv” in =PPMT?

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

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

10. What is the type of argument “nper” in =PPMT?

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

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

11. What is the type of argument “per” in =PPMT?

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

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

12. Is argument “fv” required in =PPMT?

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

Explanation: “fv” is optional.

13. What is the type of argument “fv” in =PPMT?

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

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

14. Is =PPMT volatile?

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

Explanation: PPMT is not volatile.

15. Is argument “type” required in =PPMT?

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

Explanation: “type” is optional.