Financial =XIRR(values, dates, [guess])

Quiz =XIRR — 15 Questions

15 quiz questions about =XIRR — test syntax, arguments, examples & errors!

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

← XIRR ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which category does =XIRR belong to?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

What usually causes #VALUE! in =XIRR?

Question 4 of 15 4/15

Which is the correct syntax of =XIRR?

Question 5 of 15 5/15

What is the fix for #NUM! in =XIRR?

Question 6 of 15 6/15

How many arguments does =XIRR have in total?

Question 7 of 15 7/15

In =XIRR, which is argument #2?

Question 8 of 15 8/15

Which formula is a valid example of =XIRR?

Question 9 of 15 9/15

What is the type of argument “dates” in =XIRR?

Question 10 of 15 10/15

How many optional arguments does =XIRR have?

Question 11 of 15 11/15

Is argument “dates” required in =XIRR?

Question 12 of 15 12/15

Which statement about =XIRR is correct?

Question 13 of 15 13/15

Does =XIRR return a dynamic array?

Question 14 of 15 14/15

In =XIRR, which is argument #3?

Question 15 of 15 15/15

Which function is related to =XIRR?

Click a question to see the answer.

1. Which category does =XIRR belong to?

A. Financial ✓
B. Text
C. Logical
D. Database

Explanation: Category is “Financial”.

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

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

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

3. What usually causes #VALUE! in =XIRR?

A. Text is always ignored
B. Output is always a dynamic array
C. Only works in old versions
D. If any number in dates is not a valid date, XIRR returns the #VALUE! error value. ✓

Explanation: If any number in dates is not a valid date, XIRR returns the #VALUE! error value. — Fix: تاریخ‌ها را با تابع DATE وارد کنید و بررسی کنید سلول‌ها واقعاً تاریخ باشند، نه متن.

4. Which is the correct syntax of =XIRR?

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

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

5. What is the fix for #NUM! in =XIRR?

A. یکی از مقادیر dates تاریخ معتبری نیست.
B. Check the data or enter an initial guess ✓
C. Requires add-in
D. Output is always a dynamic array

Explanation: XIRR expects at least one positive cash flow and one negative cash flow; otherwise, XIRR returns the #NUM! error value. If any number in dates precedes the starting date, XIRR returns the #NUM! error value. If values and dates contain a different number of values, XIRR returns the #NUM! error value. If XIRR can't find a result that works after 100 tries, the #NUM! error value is returned. — Fix: Check the data or enter an initial guess

6. How many arguments does =XIRR have in total?

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

Explanation: =XIRR has 2 required, 1 optional (3 total).

7. In =XIRR, which is argument #2?

A. dates ✓
B. criteria
C. guess
D. lookup_value

Explanation: Argument #2 is “dates”.

8. Which formula is a valid example of =XIRR?

A. =XIRR(A3:A7, B3:B7, 0.1, 0)
B. XIRR(A3:A7, B3:B7, 0.1)
C. =XIRR(A3:A7, B3:B7, 0.1) ✓
D. =IRR(A3:A7, B3:B7, 0.1)

Explanation: Correct example: =XIRR(A3:A7, B3:B7, 0.1)

9. What is the type of argument “dates” in =XIRR?

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

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

10. How many optional arguments does =XIRR have?

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

Explanation: =XIRR has 2 required, 1 optional (3 total).

11. Is argument “dates” required in =XIRR?

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

Explanation: “dates” is required.

12. Which statement about =XIRR is correct?

A. Output is always a dynamic array
B. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. ✓
C. In most cases you do not need to provide guess for the XIRR calculation. If omitted, guess is assumed to be 0.1 (10 percent).
D. Only works in old versions

Explanation: Correct: Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.

13. Does =XIRR return a dynamic array?

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

Explanation: XIRR does not spill.

14. In =XIRR, which is argument #3?

A. range
B. guess ✓
C. dates
D. values

Explanation: Argument #3 is “guess”.

15. Which function is related to =XIRR?

A. MAXIFS
B. SIGN
C. IRR ✓
D. NORMDIST

Explanation: “IRR” is related to XIRR.