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 arguments does =XNPV have in total?

Question 2 of 15 2/15

In =XNPV, which is argument #1?

Question 3 of 15 3/15

Which function is NOT related to =XNPV?

Question 4 of 15 4/15

Which category does =XNPV belong to?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Does =XNPV return a dynamic array?

Question 7 of 15 7/15

In =XNPV, which is argument #3?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Is =XNPV volatile?

Question 10 of 15 10/15

Since which Excel version is =XNPV available?

Question 11 of 15 11/15

Which is the correct syntax of =XNPV?

Question 12 of 15 12/15

Which use case fits =XNPV?

Question 13 of 15 13/15

In =XNPV, which is argument #2?

Question 14 of 15 14/15

How many optional arguments does =XNPV have?

Question 15 of 15 15/15

Which statement about =XNPV is correct?

Click a question to see the answer.

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

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

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

2. In =XNPV, which is argument #1?

A. criteria
B. rate ✓
C. dates
D. range

Explanation: Argument #1 is “rate”.

3. Which function is NOT related to =XNPV?

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

Explanation: “RADIANS” is not related to XNPV.

4. Which category does =XNPV belong to?

A. Statistical
B. Financial ✓
C. Engineering
D. Information

Explanation: Category is “Financial”.

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

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

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

6. Does =XNPV return a dynamic array?

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

Explanation: XNPV does not spill.

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

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

Explanation: Argument #3 is “dates”.

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

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

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

9. Is =XNPV volatile?

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

Explanation: XNPV is not volatile.

10. Since which Excel version is =XNPV available?

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

Explanation: Version: “All versions”.

11. Which is the correct syntax of =XNPV?

A. =XNPV(rate, values, dates) ✓
B. XNPV(rate, values, dates)
C. =XNPV(rate, values, dates, 0)
D. =NPV(rate, values, dates)

Explanation: Correct syntax: =XNPV(rate, values, dates)

12. Which use case fits =XNPV?

A. Financial Calculations ✓
B. Advanced Formulas
C. Comparation
D. Loans & Installments

Explanation: Use case “Financial Calculations” fits XNPV.

13. In =XNPV, which is argument #2?

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

Explanation: Argument #2 is “values”.

14. How many optional arguments does =XNPV have?

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

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

15. Which statement about =XNPV is correct?

A. Output is always a dynamic array
B. 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. ✓
C. Numbers in dates are truncated to integers.
D. Select entire column for best performance

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.