Date & Time =DATEVALUE(date_text)

Quiz =DATEVALUE — 10 Questions

10 quiz questions about =DATEVALUE — test syntax, arguments, examples & errors!

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

← DATEVALUE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =DATEVALUE is correct?

Question 2 of 10 2/10

Is argument “dATEVALUE” required in =DATEVALUE?

Question 3 of 10 3/10

Which function is related to =DATEVALUE?

Question 4 of 10 4/10

What is the output type of =DATEVALUE?

Question 5 of 10 5/10

Is =DATEVALUE volatile?

Question 6 of 10 6/10

What usually causes #VALUE! in =DATEVALUE?

Question 7 of 10 7/10

Which function is NOT related to =DATEVALUE?

Question 8 of 10 8/10

Since which Excel version is =DATEVALUE available?

Question 9 of 10 9/10

What is the fix for #VALUE! in =DATEVALUE?

Question 10 of 10 10/10

In =DATEVALUE, which is argument #1?

Click a question to see the answer.

1. Which statement about =DATEVALUE is correct?

A. Text is always ignored
B. Select entire column for best performance
C. Most functions automatically convert date values to serial numbers.
D. Excel stores dates as sequential serial numbers so that 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,447 days after January 1, 1900. ✓

Explanation: Correct: Excel stores dates as sequential serial numbers so that 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,447 days after January 1, 1900.

2. Is argument “dATEVALUE” required in =DATEVALUE?

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

Explanation: “dATEVALUE” is optional.

3. Which function is related to =DATEVALUE?

A. TEXT ✓
B. F.DIST.RT
C. CRITBINOM
D. COUNTA

Explanation: “TEXT” is related to DATEVALUE.

4. What is the output type of =DATEVALUE?

A. Logical
B. Number ✓
C. Date
D. Array

Explanation: Output is “Number”.

5. Is =DATEVALUE volatile?

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

Explanation: DATEVALUE is not volatile.

6. What usually causes #VALUE! in =DATEVALUE?

A. function returns the #VALUE! error value if the value of the ✓
B. Requires add-in
C. Select entire column for best performance
D. Text is always ignored

Explanation: function returns the #VALUE! error value if the value of the — Fix: Check the text format, or build the date with DATE

7. Which function is NOT related to =DATEVALUE?

A. TEXT
B. VALUE
C. IMSEC ✓
D. TIMEVALUE

Explanation: “IMSEC” is not related to DATEVALUE.

8. Since which Excel version is =DATEVALUE available?

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

Explanation: Version: “All versions”.

9. What is the fix for #VALUE! in =DATEVALUE?

A. Requires add-in
B. Select entire column for best performance
C. Check the text format, or build the date with DATE ✓
D. Text is always ignored

Explanation: function returns the #VALUE! error value if the value of the — Fix: Check the text format, or build the date with DATE

10. In =DATEVALUE, which is argument #1?

A. date_text ✓
B. dATEVALUE
C. criteria
D. lookup_value

Explanation: Argument #1 is “date_text”.