Financial =MIRR(values, finance_rate, reinvest_rate)

Quiz =MIRR — 10 Questions

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

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

← MIRR ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “finance_rate” required in =MIRR?

Question 2 of 10 2/10

What is the type of argument “values” in =MIRR?

Question 3 of 10 3/10

Which function is related to =MIRR?

Question 4 of 10 4/10

Since which Excel version is =MIRR available?

Question 5 of 10 5/10

Which statement about =MIRR is correct?

Question 6 of 10 6/10

Which formula is a valid example of =MIRR?

Question 7 of 10 7/10

How many optional arguments does =MIRR have?

Question 8 of 10 8/10

In =MIRR, which is argument #1?

Question 9 of 10 9/10

Which function is NOT related to =MIRR?

Question 10 of 10 10/10

Is argument “reinvest_rate” required in =MIRR?

Click a question to see the answer.

1. Is argument “finance_rate” required in =MIRR?

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

Explanation: “finance_rate” is required.

2. What is the type of argument “values” in =MIRR?

A. Date
B. Array
C. Logical
D. Range ✓

Explanation: Type of “values” is “Range”.

3. Which function is related to =MIRR?

A. PY
B. LEN
C. IRR ✓
D. TRUE

Explanation: “IRR” is related to MIRR.

4. Since which Excel version is =MIRR available?

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

Explanation: Version: “All versions”.

5. Which statement about =MIRR is correct?

A. Text is always ignored
B. Requires add-in
C. Volatile and recalculates every time
D. MIRR uses the order of values to interpret the order of cash flows. Be sure to enter your payment and income values in the sequence you want and with the correct signs (positive values for cash received, negative values for cash paid). ✓

Explanation: Correct: MIRR uses the order of values to interpret the order of cash flows. Be sure to enter your payment and income values in the sequence you want and with the correct signs (positive values for cash received, negative values for cash paid).

6. Which formula is a valid example of =MIRR?

A. MIRR(A2:A7, A8, A9)
B. =IRR(A2:A7, A8, A9)
C. =MIRR(A2:A7, A8, A9) ✓
D. =MIRR(A2:A7, A8, A9, 0)

Explanation: Correct example: =MIRR(A2:A7, A8, A9)

7. How many optional arguments does =MIRR have?

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

Explanation: =MIRR has 3 required, 0 optional (3 total).

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

A. lookup_value
B. values ✓
C. reinvest_rate
D. criteria

Explanation: Argument #1 is “values”.

9. Which function is NOT related to =MIRR?

A. NPV
B. YEARFRAC ✓
C. IRR
D. XIRR

Explanation: “YEARFRAC” is not related to MIRR.

10. Is argument “reinvest_rate” required in =MIRR?

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

Explanation: “reinvest_rate” is required.