Financial =XNPV(rate, values, dates)

Quiz =XNPV — 10 Questions

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

Question 1 of 10 1/10

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

Question 2 of 10 2/10

What usually causes #VALUE! in =XNPV?

Question 3 of 10 3/10

In =XNPV, which is argument #3?

Question 4 of 10 4/10

What usually causes #NUM! in =XNPV?

Question 5 of 10 5/10

Which function is related to =XNPV?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Since which Excel version is =XNPV available?

Question 9 of 10 9/10

Which use case fits =XNPV?

Question 10 of 10 10/10

Is argument “rate” required in =XNPV?

Click a question to see the answer.

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

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

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

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

A. Volatile and recalculates every time
B. Select entire column for best performance
C. Output is always a dynamic array
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 وارد کنید.

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

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

Explanation: Argument #3 is “dates”.

4. 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. Select entire column for best performance
C. یکی از آرگومان‌ها غیرعددی است یا مقداری در dates تاریخ معتبری نیست.
D. Requires add-in

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

5. Which function is related to =XNPV?

A. BAHTTEXT
B. BINOMDIST
C. ENCODEURL
D. NPV ✓

Explanation: “NPV” is related to XNPV.

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

A. Check the two ranges ✓
B. Text is always ignored
C. Requires add-in
D. Select entire column for best performance

7. What is the type of argument “values” in =XNPV?

A. Text
B. Value
C. Range ✓
D. Reference

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

8. Since which Excel version is =XNPV available?

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

Explanation: Version: “All versions”.

9. Which use case fits =XNPV?

A. Text Manipulation
B. Loans & Installments
C. Forecasting & Trends
D. Financial Calculations ✓

Explanation: Use case “Financial Calculations” fits XNPV.

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

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

Explanation: “rate” is required.