Date & Time =DAY(serial_number)

Quiz =DAY — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Which is the correct syntax of =DAY?

Question 2 of 15 2/15

How many optional arguments does =DAY have?

Question 3 of 15 3/15

Which use case fits =DAY?

Question 4 of 15 4/15

Is =DAY volatile?

Question 5 of 15 5/15

How many arguments does =DAY have in total?

Question 6 of 15 6/15

Does =DAY return a dynamic array?

Question 7 of 15 7/15

Is argument “serial_number” required in =DAY?

Question 8 of 15 8/15

In =DAY, which is argument #1?

Question 9 of 15 9/15

Which category does =DAY belong to?

Question 10 of 15 10/15

Which statement about =DAY is correct?

Question 11 of 15 11/15

How many required arguments does =DAY have?

Question 12 of 15 12/15

What is the type of argument “serial_number” in =DAY?

Question 13 of 15 13/15

Which function is NOT related to =DAY?

Question 14 of 15 14/15

Which formula is a valid example of =DAY?

Question 15 of 15 15/15

What is the output type of =DAY?

Click a question to see the answer.

1. 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)

2. How many optional arguments does =DAY have?

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

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

3. Which use case fits =DAY?

A. Date & Time Calculations ✓
B. Text Manipulation
C. Dynamic Ranges & Dashboards
D. Rounding & Numeric

Explanation: Use case “Date & Time Calculations” fits DAY.

4. Is =DAY volatile?

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

Explanation: DAY is not volatile.

5. How many arguments does =DAY have in total?

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

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

6. Does =DAY return a dynamic array?

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

Explanation: DAY does not spill.

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

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

Explanation: “serial_number” is required.

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

A. serial_number ✓
B. range
C. criteria
D. lookup_value

Explanation: Argument #1 is “serial_number”.

9. Which category does =DAY belong to?

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

Explanation: Category is “Date & Time”.

10. Which statement about =DAY is correct?

A. Requires add-in
B. 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. ✓
C. Select entire column for best performance
D. Values returned by the YEAR, MONTH and DAY functions will be Gregorian values regardless of the display format for the supplied date value. For example, if the display format of the supplied date is Hijri, the returned values for the YEAR, MONTH and DAY functions will be values associated with the equivalent Gregorian date.

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.

11. How many required arguments does =DAY have?

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

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

12. What is the type of argument “serial_number” in =DAY?

A. Any type ✓
B. Text
C. Number
D. Reference

Explanation: Type of “serial_number” is “Any type”.

13. Which function is NOT related to =DAY?

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

Explanation: “SUBTOTAL” is not related to DAY.

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

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

Explanation: Correct example: =DAY(A2)

15. What is the output type of =DAY?

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

Explanation: Output is “Number”.