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

In =DAY, which is argument #1?

Question 2 of 10 2/10

Which function is related to =DAY?

Question 3 of 10 3/10

Which statement about =DAY is correct?

Question 4 of 10 4/10

Which use case fits =DAY?

Question 5 of 10 5/10

How many optional arguments does =DAY have?

Question 6 of 10 6/10

Is =DAY volatile?

Question 7 of 10 7/10

Which is the correct syntax of =DAY?

Question 8 of 10 8/10

How many required arguments does =DAY have?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Which function is NOT related to =DAY?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “serial_number”.

2. Which function is related to =DAY?

A. DATE ✓
B. MINUTE
C. FUNC986
D. ISNA

Explanation: “DATE” is related to DAY.

3. Which statement about =DAY is correct?

A. Requires add-in
B. Volatile and recalculates every time
C. Output is always a dynamic array
D. 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. ✓

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 use case fits =DAY?

A. Date & Time Calculations ✓
B. Loans & Installments
C. Scientific & Unit Conversion
D. Conditional Aggregation

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

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. Is =DAY volatile?

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

Explanation: DAY is not volatile.

7. Which is the correct syntax of =DAY?

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

Explanation: Correct syntax: =DAY(serial_number)

8. How many required arguments does =DAY have?

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

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

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

A. Value
B. Number
C. Logical
D. Any type ✓

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

10. Which function is NOT related to =DAY?

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

Explanation: “IMDIV” is not related to DAY.