Date & Time =DAY(serial_number)

Quiz =DAY — 10 Questions

10 quiz questions about =DAY — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← DAY ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is =DAY volatile?

Question 2 of 10 2/10

Which function is related to =DAY?

Question 3 of 10 3/10

How many optional arguments does =DAY have?

Question 4 of 10 4/10

Which statement about =DAY is correct?

Question 5 of 10 5/10

Which formula is a valid example of =DAY?

Question 6 of 10 6/10

Is argument “serial_number” required in =DAY?

Question 7 of 10 7/10

Which is the correct syntax of =DAY?

Question 8 of 10 8/10

Does =DAY return a dynamic array?

Question 9 of 10 9/10

Which function is NOT related to =DAY?

Question 10 of 10 10/10

Which category does =DAY belong to?

Click a question to see the answer.

1. Is =DAY volatile?

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

Explanation: DAY is not volatile.

2. Which function is related to =DAY?

A. NEGBINOM.DIST
B. COUPDAYSNC
C. DEC2OCT
D. DATE ✓

Explanation: “DATE” is related to DAY.

3. How many optional arguments does =DAY have?

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

Explanation: =DAY has 1 required, 0 optional (1 total).

4. Which statement about =DAY is correct?

A. Microsoft Excel stores dates as sequential serial numbers so 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,448 days after January 1, 1900. ✓
B. Text is always ignored
C. Select entire column for best performance
D. Requires add-in

Explanation: Correct: Microsoft Excel stores dates as sequential serial numbers so 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,448 days after January 1, 1900.

5. Which formula is a valid example of =DAY?

A. =DAY(A2, 0)
B. =DATE(A2)
C. =DAY(A2) ✓
D. DAY(A2)

Explanation: Correct example: =DAY(A2)

6. Is argument “serial_number” required in =DAY?

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

Explanation: “serial_number” is required.

7. Which is the correct syntax of =DAY?

A. =DAY(serial_number) ✓
B. =DATE(serial_number)
C. DAY(serial_number)
D. =DAY(serial_number, 0)

Explanation: Correct syntax: =DAY(serial_number)

8. Does =DAY return a dynamic array?

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

Explanation: DAY does not spill.

9. Which function is NOT related to =DAY?

A. DATE
B. WEEKDAY
C. MONTH
D. VALUETOTEXT ✓

Explanation: “VALUETOTEXT” is not related to DAY.

10. Which category does =DAY belong to?

A. Date & Time ✓
B. Financial
C. Compatibility
D. Cube

Explanation: Category is “Date & Time”.