Financial =CUMIPMT(rate, nper, pv, start_period, end_period, type)

Quiz =CUMIPMT — 10 Questions

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

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

← CUMIPMT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many optional arguments does =CUMIPMT have?

Question 2 of 10 2/10

Is argument “end_period” required in =CUMIPMT?

Question 3 of 10 3/10

Which formula is a valid example of =CUMIPMT?

Question 4 of 10 4/10

Which statement about =CUMIPMT is correct?

Question 5 of 10 5/10

Which is the correct syntax of =CUMIPMT?

Question 6 of 10 6/10

Which function is NOT related to =CUMIPMT?

Question 7 of 10 7/10

Since which Excel version is =CUMIPMT available?

Question 8 of 10 8/10

In =CUMIPMT, which is argument #1?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

How many required arguments does =CUMIPMT have?

Click a question to see the answer.

1. How many optional arguments does =CUMIPMT have?

A. 6
B. 2
C. 1
D. 0 ✓

Explanation: =CUMIPMT has 6 required, 0 optional (6 total).

2. Is argument “end_period” required in =CUMIPMT?

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

Explanation: “end_period” is required.

3. Which formula is a valid example of =CUMIPMT?

A. =CUMIPMT(A2/12,A3*12,A4,13,24,0) ✓
B. =CUMIPMT(A2/12,A3*12,A4,13,24,0, 0)
C. =CUMPRINC(A2/12,A3*12,A4,13,24,0)
D. CUMIPMT(A2/12,A3*12,A4,13,24,0)

Explanation: Correct example: =CUMIPMT(A2/12,A3*12,A4,13,24,0)

4. Which statement about =CUMIPMT is correct?

A. Text is always ignored
B. 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 10 percent, use 10%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 10% for rate and 4 for nper. ✓
C. Output is always a dynamic array
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 an annual interest rate of 10 percent, use 10%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 10% for rate and 4 for nper.

5. Which is the correct syntax of =CUMIPMT?

A. CUMIPMT(rate, nper, pv, start_period, end_period, type)
B. =CUMPRINC(rate, nper, pv, start_period, end_period, type)
C. =CUMIPMT(rate, nper, pv, start_period, end_period, type, 0)
D. =CUMIPMT(rate, nper, pv, start_period, end_period, type) ✓

Explanation: Correct syntax: =CUMIPMT(rate, nper, pv, start_period, end_period, type)

6. Which function is NOT related to =CUMIPMT?

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

Explanation: “SLOPE” is not related to CUMIPMT.

7. Since which Excel version is =CUMIPMT available?

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

Explanation: Version: “All versions”.

8. In =CUMIPMT, which is argument #1?

A. start_period
B. type
C. pv
D. rate ✓

Explanation: Argument #1 is “rate”.

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

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

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

10. How many required arguments does =CUMIPMT have?

A. 8
B. 5
C. 7
D. 6 ✓

Explanation: =CUMIPMT has 6 required, 0 optional (6 total).