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

What usually causes #VALUE! in =DATEVALUE?

Question 2 of 10 2/10

Which use case fits =DATEVALUE?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

How many optional arguments does =DATEVALUE have?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which is the correct syntax of =DATEVALUE?

Question 7 of 10 7/10

Which statement about =DATEVALUE is correct?

Question 8 of 10 8/10

Does =DATEVALUE return a dynamic array?

Question 9 of 10 9/10

Which function is related to =DATEVALUE?

Question 10 of 10 10/10

Which function is NOT related to =DATEVALUE?

Click a question to see the answer.

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

A. Text is always ignored
B. Output is always a dynamic array
C. function returns the #VALUE! error value if the value of the ✓
D. Requires add-in

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

A. Securities & Bonds
B. Advanced Formulas
C. Depreciation
D. Data Cleaning ✓

Explanation: Use case “Data Cleaning” fits DATEVALUE.

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

A. Only works in old versions
B. Output is always a dynamic array
C. Text is always ignored
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

4. How many optional arguments does =DATEVALUE have?

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

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

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

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

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

6. Which is the correct syntax of =DATEVALUE?

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

Explanation: Correct syntax: =DATEVALUE(date_text)

7. Which statement about =DATEVALUE is correct?

A. 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. ✓
B. Select entire column for best performance
C. Only works in old versions
D. Most functions automatically convert date values to serial numbers.

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. Does =DATEVALUE return a dynamic array?

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

Explanation: DATEVALUE does not spill.

9. Which function is related to =DATEVALUE?

A. REGEXEXTRACT
B. COS
C. BESSELY
D. TEXT ✓

Explanation: “TEXT” is related to DATEVALUE.

10. Which function is NOT related to =DATEVALUE?

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

Explanation: “AMORDEGRC” is not related to DATEVALUE.