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

Which is the correct syntax of =DATEVALUE?

Question 3 of 10 3/10

How many optional arguments does =DATEVALUE have?

Question 4 of 10 4/10

Is argument “date_text” required in =DATEVALUE?

Question 5 of 10 5/10

Since which Excel version is =DATEVALUE available?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which function is related to =DATEVALUE?

Question 8 of 10 8/10

In =DATEVALUE, which is argument #1?

Question 9 of 10 9/10

In =DATEVALUE, which is argument #2?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which statement about =DATEVALUE is correct?

A. Only works in old versions
B. Requires add-in
C. 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. ✓
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.

2. Which is the correct syntax of =DATEVALUE?

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

Explanation: Correct syntax: =DATEVALUE(date_text)

3. How many optional arguments does =DATEVALUE have?

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

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

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

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

Explanation: “date_text” is required.

5. Since which Excel version is =DATEVALUE available?

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

Explanation: Version: “All versions”.

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

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

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

7. Which function is related to =DATEVALUE?

A. CUMPRINC
B. RTD
C. TEXT ✓
D. ROUNDUP

Explanation: “TEXT” is related to DATEVALUE.

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

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

Explanation: Argument #1 is “date_text”.

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

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

Explanation: Argument #2 is “dATEVALUE”.

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

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

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