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

Quiz =CUMPRINC — 10 Questions

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

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

← CUMPRINC ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =CUMPRINC?

Question 2 of 10 2/10

Is argument “pv” required in =CUMPRINC?

Question 3 of 10 3/10

What usually causes #NUM! in =CUMPRINC?

Question 4 of 10 4/10

Which function is related to =CUMPRINC?

Question 5 of 10 5/10

What is the type of argument “start_period” in =CUMPRINC?

Question 6 of 10 6/10

Which statement about =CUMPRINC is correct?

Question 7 of 10 7/10

Is argument “start_period” required in =CUMPRINC?

Question 8 of 10 8/10

How many arguments does =CUMPRINC have in total?

Question 9 of 10 9/10

Does =CUMPRINC return a dynamic array?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. What is the output type of =CUMPRINC?

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

Explanation: Output is “Number”.

2. Is argument “pv” required in =CUMPRINC?

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

Explanation: “pv” is required.

3. What usually causes #NUM! in =CUMPRINC?

A. Requires add-in
B. Volatile and recalculates every time
C. Only works in old versions
D. If rate ≤ 0, nper ≤ 0, or pv ≤ 0, CUMPRINC returns the #NUM! error value. If start_period < 1, end_period < 1, or start_period > end_period, CUMPRINC returns the #NUM! error value. If type is any number other than 0 or 1, CUMPRINC returns the #NUM! error value. ✓

Explanation: If rate ≤ 0, nper ≤ 0, or pv ≤ 0, CUMPRINC returns the #NUM! error value. If start_period < 1, end_period < 1, or start_period > end_period, CUMPRINC returns the #NUM! error value. If type is any number other than 0 or 1, CUMPRINC returns the #NUM! error value. — Fix: Check the inputs and the order of the start and end payments

4. Which function is related to =CUMPRINC?

A. CUMIPMT ✓
B. NORMDIST
C. IMSECH
D. GAMMA.INV

Explanation: “CUMIPMT” is related to CUMPRINC.

5. What is the type of argument “start_period” in =CUMPRINC?

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

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

6. Which statement about =CUMPRINC is correct?

A. Output is always a dynamic array
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 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% 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 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% for rate and 4 for nper.

7. Is argument “start_period” required in =CUMPRINC?

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

Explanation: “start_period” is required.

8. How many arguments does =CUMPRINC have in total?

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

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

9. Does =CUMPRINC return a dynamic array?

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

Explanation: CUMPRINC does not spill.

10. What is the type of argument “pv” in =CUMPRINC?

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

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