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

How many arguments does =DAY have in total?

Question 2 of 10 2/10

Which formula is a valid example of =DAY?

Question 3 of 10 3/10

Which statement about =DAY is correct?

Question 4 of 10 4/10

Which category does =DAY belong to?

Question 5 of 10 5/10

How many optional arguments does =DAY have?

Question 6 of 10 6/10

Which use case fits =DAY?

Question 7 of 10 7/10

Which function is NOT related to =DAY?

Question 8 of 10 8/10

In =DAY, which is argument #1?

Question 9 of 10 9/10

How many required arguments does =DAY have?

Question 10 of 10 10/10

Which function is related to =DAY?

Click a question to see the answer.

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

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

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

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

3. 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. Requires add-in
C. Text is always ignored
D. Volatile and recalculates every time

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.

4. Which category does =DAY belong to?

A. Information
B. Lookup & Reference
C. Math & Trig
D. Date & Time ✓

Explanation: Category is “Date & Time”.

5. How many optional arguments does =DAY have?

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

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

6. Which use case fits =DAY?

A. Date & Time Calculations ✓
B. Numbering & Sample Data
C. Financial Calculations
D. Conditional Aggregation

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

7. Which function is NOT related to =DAY?

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

Explanation: “CSCH” is not related to DAY.

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

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

Explanation: Argument #1 is “serial_number”.

9. How many required arguments does =DAY have?

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

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

10. Which function is related to =DAY?

A. STDEVP
B. DATE ✓
C. AVEDEV
D. ASINH

Explanation: “DATE” is related to DAY.