Date & Time =DATEVALUE(date_text)

Quiz =DATEVALUE — 15 Questions

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

Question 1 of 15 1/15

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

Question 2 of 15 2/15

Which statement about =DATEVALUE is correct?

Question 3 of 15 3/15

Which is the correct syntax of =DATEVALUE?

Question 4 of 15 4/15

Does =DATEVALUE return a dynamic array?

Question 5 of 15 5/15

What is the type of argument “date_text” in =DATEVALUE?

Question 6 of 15 6/15

Which function is NOT related to =DATEVALUE?

Question 7 of 15 7/15

In =DATEVALUE, which is argument #2?

Question 8 of 15 8/15

In =DATEVALUE, which is argument #1?

Question 9 of 15 9/15

What is the type of argument “dATEVALUE” in =DATEVALUE?

Question 10 of 15 10/15

How many arguments does =DATEVALUE have in total?

Question 11 of 15 11/15

What usually causes #VALUE! in =DATEVALUE?

Question 12 of 15 12/15

Is =DATEVALUE volatile?

Question 13 of 15 13/15

Since which Excel version is =DATEVALUE available?

Question 14 of 15 14/15

Which category does =DATEVALUE belong to?

Question 15 of 15 15/15

Which formula is a valid example of =DATEVALUE?

Click a question to see the answer.

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

A. Select entire column for best performance
B. Only works in old versions
C. Volatile and recalculates every time
D. Check the text format, or build the date with DATE ✓

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

2. Which statement about =DATEVALUE is correct?

A. Volatile and recalculates every time
B. 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. ✓
C. Requires add-in
D. Select entire column for best performance

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.

3. Which is the correct syntax of =DATEVALUE?

A. =DATEVALUE(date_text, 0)
B. DATEVALUE(date_text)
C. =DATEVALUE(date_text) ✓
D. =TEXT(date_text)

Explanation: Correct syntax: =DATEVALUE(date_text)

4. Does =DATEVALUE return a dynamic array?

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

Explanation: DATEVALUE does not spill.

5. What is the type of argument “date_text” in =DATEVALUE?

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

Explanation: Type of “date_text” is “Text”.

6. Which function is NOT related to =DATEVALUE?

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

Explanation: “MIDB” is not related to DATEVALUE.

7. In =DATEVALUE, which is argument #2?

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

Explanation: Argument #2 is “dATEVALUE”.

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

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

Explanation: Argument #1 is “date_text”.

9. What is the type of argument “dATEVALUE” in =DATEVALUE?

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

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

10. How many arguments does =DATEVALUE have in total?

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

Explanation: =DATEVALUE has 1 required, 1 optional (2 total).

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

A. Output is always a dynamic array
B. function returns the #VALUE! error value if the value of the ✓
C. Only works in old versions
D. Volatile and recalculates every time

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

12. Is =DATEVALUE volatile?

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

Explanation: DATEVALUE is not volatile.

13. Since which Excel version is =DATEVALUE available?

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

Explanation: Version: “All versions”.

14. Which category does =DATEVALUE belong to?

A. Lookup & Reference
B. Math & Trig
C. Logical
D. Date & Time ✓

Explanation: Category is “Date & Time”.

15. Which formula is a valid example of =DATEVALUE?

A. =DATEVALUE("8/22/2011") ✓
B. DATEVALUE("8/22/2011")
C. =DATEVALUE("8/22/2011", 0)
D. =TEXT("8/22/2011")

Explanation: Correct example: =DATEVALUE("8/22/2011")