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

How many required arguments does =MIRR have?

Question 2 of 10 2/10

Is =MIRR volatile?

Question 3 of 10 3/10

In =MIRR, which is argument #2?

Question 4 of 10 4/10

Is argument “reinvest_rate” required in =MIRR?

Question 5 of 10 5/10

Which formula is a valid example of =MIRR?

Question 6 of 10 6/10

Which statement about =MIRR is correct?

Question 7 of 10 7/10

Is argument “values” required in =MIRR?

Question 8 of 10 8/10

What is the output type of =MIRR?

Question 9 of 10 9/10

In =MIRR, which is argument #1?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. How many required arguments does =MIRR have?

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

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

2. Is =MIRR volatile?

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

Explanation: MIRR is not volatile.

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

A. lookup_value
B. criteria
C. finance_rate ✓
D. value

Explanation: Argument #2 is “finance_rate”.

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

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

Explanation: “reinvest_rate” is required.

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

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

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

6. Which statement about =MIRR is correct?

A. Requires add-in
B. Text is always ignored
C. 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). ✓
D. Select entire column for best performance

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).

7. Is argument “values” required in =MIRR?

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

Explanation: “values” is required.

8. What is the output type of =MIRR?

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

Explanation: Output is “Number”.

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

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

Explanation: Argument #1 is “values”.

10. What is the type of argument “reinvest_rate” in =MIRR?

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

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