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 output type of =DATEVALUE?

Question 2 of 15 2/15

In =DATEVALUE, which is argument #2?

Question 3 of 15 3/15

What is the type of argument “date_text” in =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 “dATEVALUE” in =DATEVALUE?

Question 6 of 15 6/15

Is =DATEVALUE volatile?

Question 7 of 15 7/15

How many required arguments does =DATEVALUE have?

Question 8 of 15 8/15

In =DATEVALUE, which is argument #1?

Question 9 of 15 9/15

Which function is related to =DATEVALUE?

Question 10 of 15 10/15

How many arguments does =DATEVALUE have in total?

Question 11 of 15 11/15

Which function is NOT related to =DATEVALUE?

Question 12 of 15 12/15

Which category does =DATEVALUE belong to?

Question 13 of 15 13/15

Is argument “dATEVALUE” required in =DATEVALUE?

Question 14 of 15 14/15

Which statement about =DATEVALUE is correct?

Question 15 of 15 15/15

How many optional arguments does =DATEVALUE have?

Click a question to see the answer.

1. What is the output type of =DATEVALUE?

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

Explanation: Output is “Number”.

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

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

Explanation: Argument #2 is “dATEVALUE”.

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

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

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

4. Does =DATEVALUE return a dynamic array?

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

Explanation: DATEVALUE does not spill.

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

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

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

6. Is =DATEVALUE volatile?

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

Explanation: DATEVALUE is not volatile.

7. How many required arguments does =DATEVALUE have?

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

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

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

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

Explanation: Argument #1 is “date_text”.

9. Which function is related to =DATEVALUE?

A. TEXT ✓
B. ERF
C. YIELD
D. ISLOGICAL

Explanation: “TEXT” is related to DATEVALUE.

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

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

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

11. Which function is NOT related to =DATEVALUE?

A. TIMEVALUE
B. T.DIST.2T ✓
C. VALUE
D. TEXT

Explanation: “T.DIST.2T” is not related to DATEVALUE.

12. Which category does =DATEVALUE belong to?

A. Information
B. Date & Time ✓
C. Engineering
D. Cube

Explanation: Category is “Date & Time”.

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

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

Explanation: “dATEVALUE” is optional.

14. Which statement about =DATEVALUE is correct?

A. Volatile and recalculates every time
B. Only works in old versions
C. Select entire column for best performance
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.

15. How many optional arguments does =DATEVALUE have?

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

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