Financial =IRR(values, [guess])

Quiz =IRR — 10 Questions

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

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

← IRR ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =IRR?

Question 2 of 10 2/10

Is argument “if” required in =IRR?

Question 3 of 10 3/10

How many optional arguments does =IRR have?

Question 4 of 10 4/10

Is argument “iRR” required in =IRR?

Question 5 of 10 5/10

Which is the correct syntax of =IRR?

Question 6 of 10 6/10

Which function is related to =IRR?

Question 7 of 10 7/10

Since which Excel version is =IRR available?

Question 8 of 10 8/10

Which statement about =IRR is correct?

Question 9 of 10 9/10

Is =IRR volatile?

Question 10 of 10 10/10

What is the type of argument “iRR” in =IRR?

Click a question to see the answer.

1. What is the output type of =IRR?

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

Explanation: Output is “Number”.

2. Is argument “if” required in =IRR?

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

Explanation: “if” is optional.

3. How many optional arguments does =IRR have?

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

Explanation: =IRR has 1 required, 3 optional (4 total).

4. Is argument “iRR” required in =IRR?

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

Explanation: “iRR” is optional.

5. Which is the correct syntax of =IRR?

A. =IRR(values, [guess], 0)
B. =IRR(values, [guess]) ✓
C. IRR(values, [guess])
D. =MIRR(values, [guess])

Explanation: Correct syntax: =IRR(values, [guess])

6. Which function is related to =IRR?

A. IMSQRT
B. MIRR ✓
C. ISODD
D. BIN2OCT

Explanation: “MIRR” is related to IRR.

7. Since which Excel version is =IRR available?

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

Explanation: Version: “All versions”.

8. Which statement about =IRR is correct?

A. Volatile and recalculates every time
B. Select entire column for best performance
C. IRR is closely related to NPV, the net present value function. The rate of return calculated by IRR is the interest rate corresponding to a 0 (zero) net present value. The following formula demonstrates how NPV and IRR are related: ✓
D. Only works in old versions

Explanation: Correct: IRR is closely related to NPV, the net present value function. The rate of return calculated by IRR is the interest rate corresponding to a 0 (zero) net present value. The following formula demonstrates how NPV and IRR are related:

9. Is =IRR volatile?

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

Explanation: IRR is not volatile.

10. What is the type of argument “iRR” in =IRR?

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

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