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 function is related to =XIRR?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which statement about =XIRR is correct?

Question 4 of 15 4/15

Is argument “values” required in =XIRR?

Question 5 of 15 5/15

Which category does =XIRR belong to?

Question 6 of 15 6/15

Which use case fits =XIRR?

Question 7 of 15 7/15

Which formula is a valid example of =XIRR?

Question 8 of 15 8/15

What is the output type 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 required arguments does =XIRR have?

Question 11 of 15 11/15

Is =XIRR volatile?

Question 12 of 15 12/15

Which is the correct syntax of =XIRR?

Question 13 of 15 13/15

How many optional arguments does =XIRR have?

Question 14 of 15 14/15

How many arguments does =XIRR have in total?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which function is related to =XIRR?

A. IRR ✓
B. CSC
C. VARP
D. ERF.PRECISE

Explanation: “IRR” is related to XIRR.

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

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

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

3. 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. Text is always ignored
D. Requires add-in

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.

4. Is argument “values” required in =XIRR?

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

Explanation: “values” is required.

5. Which category does =XIRR belong to?

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

Explanation: Category is “Financial”.

6. Which use case fits =XIRR?

A. Error Handling
B. Worksheet Info & Navigation
C. Descriptive Statistics
D. Financial Calculations ✓

Explanation: Use case “Financial Calculations” fits XIRR.

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

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

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

8. What is the output type of =XIRR?

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

Explanation: Output is “Number”.

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

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

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

10. How many required arguments does =XIRR have?

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

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

11. Is =XIRR volatile?

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

Explanation: XIRR is not volatile.

12. Which is the correct syntax of =XIRR?

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

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

13. How many optional arguments does =XIRR have?

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

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

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

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

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

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

A. Requires add-in
B. یکی از مقادیر dates تاریخ معتبری نیست.
C. Select entire column for best performance
D. Check the data or enter an initial guess ✓

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