Financial =XNPV(rate, values, dates)

Quiz =XNPV — 15 Questions

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

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

← XNPV ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many required arguments does =XNPV have?

Question 2 of 15 2/15

What usually causes #NUM! in =XNPV?

Question 3 of 15 3/15

Which category does =XNPV belong to?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

In =XNPV, which is argument #3?

Question 6 of 15 6/15

Which function is NOT related to =XNPV?

Question 7 of 15 7/15

Which function is related to =XNPV?

Question 8 of 15 8/15

What is the type of argument “rate” in =XNPV?

Question 9 of 15 9/15

How many arguments does =XNPV have in total?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which statement about =XNPV is correct?

Question 12 of 15 12/15

Is argument “rate” required in =XNPV?

Question 13 of 15 13/15

Is argument “values” required in =XNPV?

Question 14 of 15 14/15

Does =XNPV return a dynamic array?

Question 15 of 15 15/15

What usually causes #VALUE! in =XNPV?

Click a question to see the answer.

1. How many required arguments does =XNPV have?

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

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

2. What usually causes #NUM! in =XNPV?

A. If any number in dates precedes the starting date, XNPV returns the #NUM! error value. If values and dates contain a different number of values, XNPV returns the #NUM! error value. ✓
B. Text is always ignored
C. Volatile and recalculates every time
D. Select entire column for best performance

Explanation: If any number in dates precedes the starting date, XNPV returns the #NUM! error value. If values and dates contain a different number of values, XNPV returns the #NUM! error value. — Fix: Check the two ranges

3. Which category does =XNPV belong to?

A. Statistical
B. Lookup & Reference
C. Financial ✓
D. Engineering

Explanation: Category is “Financial”.

4. What is the fix for #NUM! in =XNPV?

A. Text is always ignored
B. Check the two ranges ✓
C. Output is always a dynamic array
D. Only works in old versions

5. In =XNPV, which is argument #3?

A. lookup_value
B. range
C. dates ✓
D. value

Explanation: Argument #3 is “dates”.

6. Which function is NOT related to =XNPV?

A. PV
B. NPV
C. SWITCH ✓
D. XIRR

Explanation: “SWITCH” is not related to XNPV.

7. Which function is related to =XNPV?

A. PRICEMAT
B. SUBTOTAL
C. DVARP
D. NPV ✓

Explanation: “NPV” is related to XNPV.

8. What is the type of argument “rate” in =XNPV?

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

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

9. How many arguments does =XNPV have in total?

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

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

10. What is the type of argument “dates” in =XNPV?

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

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

11. Which statement about =XNPV is correct?

A. Output is always a dynamic array
B. Text is always ignored
C. 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. ✓
D. Volatile and recalculates every time

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.

12. Is argument “rate” required in =XNPV?

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

Explanation: “rate” is required.

13. Is argument “values” required in =XNPV?

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

Explanation: “values” is required.

14. Does =XNPV return a dynamic array?

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

Explanation: XNPV does not spill.

15. What usually causes #VALUE! in =XNPV?

A. Select entire column for best performance
B. مقداری در dates قبل از تاریخ شروع است یا تعداد values و dates برابر نیست.
C. Requires add-in
D. If any argument is nonnumeric, XNPV returns the #VALUE! error value. If any number in dates is not a valid date, XNPV returns the #VALUE! error value. ✓

Explanation: If any argument is nonnumeric, XNPV returns the #VALUE! error value. If any number in dates is not a valid date, XNPV returns the #VALUE! error value. — Fix: برای rate و values اعداد معتبر وارد کنید و تاریخ‌ها را با تابع DATE وارد کنید.