Financial =MIRR(values, finance_rate, reinvest_rate)

Quiz =MIRR — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Since which Excel version is =MIRR available?

Question 2 of 15 2/15

What is the fix for #DIV/0! in =MIRR?

Question 3 of 15 3/15

How many optional arguments does =MIRR have?

Question 4 of 15 4/15

Which function is related to =MIRR?

Question 5 of 15 5/15

What is the output type of =MIRR?

Question 6 of 15 6/15

How many required arguments does =MIRR have?

Question 7 of 15 7/15

Which is the correct syntax of =MIRR?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Is argument “values” required in =MIRR?

Question 10 of 15 10/15

What usually causes #DIV/0! in =MIRR?

Question 11 of 15 11/15

Does =MIRR return a dynamic array?

Question 12 of 15 12/15

Which statement about =MIRR is correct?

Question 13 of 15 13/15

Is argument “finance_rate” required in =MIRR?

Question 14 of 15 14/15

Which category does =MIRR belong to?

Question 15 of 15 15/15

In =MIRR, which is argument #1?

Click a question to see the answer.

1. Since which Excel version is =MIRR available?

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

Explanation: Version: “All versions”.

2. What is the fix for #DIV/0! in =MIRR?

A. Select entire column for best performance
B. Enter at least one positive and one negative amount ✓
C. Only works in old versions
D. Volatile and recalculates every time

Explanation: Otherwise, MIRR returns the #DIV/0! error value. — Fix: Enter at least one positive and one negative amount

3. How many optional arguments does =MIRR have?

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

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

4. Which function is related to =MIRR?

A. SORTBY
B. CSCH
C. PERMUT
D. IRR ✓

Explanation: “IRR” is related to MIRR.

5. What is the output type of =MIRR?

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

Explanation: Output is “Number”.

6. How many required arguments does =MIRR have?

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

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

7. Which is the correct syntax of =MIRR?

A. =MIRR(values, finance_rate, reinvest_rate) ✓
B. =IRR(values, finance_rate, reinvest_rate)
C. MIRR(values, finance_rate, reinvest_rate)
D. =MIRR(values, finance_rate, reinvest_rate, 0)

Explanation: Correct syntax: =MIRR(values, finance_rate, reinvest_rate)

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

A. Mixed
B. Reference
C. Range ✓
D. Logical

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

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

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

Explanation: “values” is required.

10. What usually causes #DIV/0! in =MIRR?

A. Volatile and recalculates every time
B. Otherwise, MIRR returns the #DIV/0! error value. ✓
C. Only works in old versions
D. Select entire column for best performance

Explanation: Otherwise, MIRR returns the #DIV/0! error value. — Fix: Enter at least one positive and one negative amount

11. Does =MIRR return a dynamic array?

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

Explanation: MIRR does not spill.

12. Which statement about =MIRR is correct?

A. Only works in old versions
B. 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). ✓
C. If n is the number of cash flows in values, frate is the finance_rate, and rrate is the reinvest_rate, then the formula for MIRR is:
D. Volatile and recalculates every time

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

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

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

Explanation: “finance_rate” is required.

14. Which category does =MIRR belong to?

A. Text
B. Date & Time
C. Financial ✓
D. Cube

Explanation: Category is “Financial”.

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

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

Explanation: Argument #1 is “values”.