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 use case fits =DATEVALUE?

Question 2 of 10 2/10

Which is the correct syntax of =DATEVALUE?

Question 3 of 10 3/10

Is argument “date_text” required in =DATEVALUE?

Question 4 of 10 4/10

Is argument “dATEVALUE” required in =DATEVALUE?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Since which Excel version is =DATEVALUE available?

Question 7 of 10 7/10

Which statement about =DATEVALUE is correct?

Question 8 of 10 8/10

What is the output type of =DATEVALUE?

Question 9 of 10 9/10

What usually causes #VALUE! in =DATEVALUE?

Question 10 of 10 10/10

Which category does =DATEVALUE belong to?

Click a question to see the answer.

1. Which use case fits =DATEVALUE?

A. Data Cleaning ✓
B. Numbering & Sample Data
C. Advanced Formulas
D. Rounding & Numeric

Explanation: Use case “Data Cleaning” fits DATEVALUE.

2. Which is the correct syntax of =DATEVALUE?

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

Explanation: Correct syntax: =DATEVALUE(date_text)

3. Is argument “date_text” required in =DATEVALUE?

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

Explanation: “date_text” is required.

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

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

Explanation: “dATEVALUE” is optional.

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

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

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

6. Since which Excel version is =DATEVALUE available?

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

Explanation: Version: “All versions”.

7. Which statement about =DATEVALUE is correct?

A. Text is always ignored
B. Only works in old versions
C. Volatile and recalculates every time
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.

8. What is the output type of =DATEVALUE?

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

Explanation: Output is “Number”.

9. 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. Text is always ignored
D. Only works in old versions

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

10. Which category does =DATEVALUE belong to?

A. Date & Time ✓
B. Compatibility
C. Statistical
D. Web

Explanation: Category is “Date & Time”.