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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
What is the type of argument “values” in =XNPV?
Explanation: Type of “values” is “Range”.
Question 2 of 10
2/10
Which category does =XNPV belong to?
Explanation: Category is “Financial”.
Question 3 of 10
3/10
Which statement about =XNPV is correct?
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.
Question 4 of 10
4/10
Which formula is a valid example of =XNPV?
Explanation: Correct example: =XNPV(.09, A2:A6, B2:B6)
Question 5 of 10
5/10
In =XNPV, which is argument #1?
Explanation: Argument #1 is “rate”.
Question 6 of 10
6/10
In =XNPV, which is argument #2?
Explanation: Argument #2 is “values”.
Question 7 of 10
7/10
What is the fix for #VALUE! in =XNPV?
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 وارد کنید.
Question 8 of 10
8/10
Which function is related to =XNPV?
Explanation: “NPV” is related to XNPV.
Question 9 of 10
9/10
Does =XNPV return a dynamic array?
Explanation: XNPV does not spill.
Question 10 of 10
10/10
What usually causes #VALUE! in =XNPV?
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 وارد کنید.