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

Quiz =XIRR — 10 Questions

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

Question 1 of 10 1/10

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

Question 2 of 10 2/10

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

Question 3 of 10 3/10

In =XIRR, which is argument #1?

Question 4 of 10 4/10

Which statement about =XIRR is correct?

Question 5 of 10 5/10

Does =XIRR return a dynamic array?

Question 6 of 10 6/10

Is argument “dates” required in =XIRR?

Question 7 of 10 7/10

Since which Excel version is =XIRR available?

Question 8 of 10 8/10

How many arguments does =XIRR have in total?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Which category does =XIRR belong to?

Click a question to see the answer.

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

A. Range ✓
B. Reference
C. Array
D. Number

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

2. What is the fix for #VALUE! in =XIRR?

A. Requires add-in
B. تاریخ‌ها را با تابع DATE وارد کنید و بررسی کنید سلول‌ها واقعاً تاریخ باشند، نه متن. ✓
C. Select entire column for best performance
D. Only works in old versions

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

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

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

Explanation: Argument #1 is “values”.

4. Which statement about =XIRR is correct?

A. 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. ✓
B. 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).
C. Requires add-in
D. Output is always a dynamic array

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.

5. Does =XIRR return a dynamic array?

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

Explanation: XIRR does not spill.

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

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

Explanation: “dates” is required.

7. Since which Excel version is =XIRR available?

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

Explanation: Version: “All versions”.

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

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

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

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

A. Output is always a dynamic array
B. Text is always ignored
C. Check the data or enter an initial guess ✓
D. Only works in old versions

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

10. Which category does =XIRR belong to?

A. Math & Trig
B. Financial ✓
C. Date & Time
D. Statistical

Explanation: Category is “Financial”.