Date & Time =MONTH(serial_number)

Quiz =MONTH — 10 Questions

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

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

← MONTH ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which is the correct syntax of =MONTH?

Question 2 of 10 2/10

Which statement about =MONTH is correct?

Question 3 of 10 3/10

What is the output type of =MONTH?

Question 4 of 10 4/10

Does =MONTH return a dynamic array?

Question 5 of 10 5/10

Which category does =MONTH belong to?

Question 6 of 10 6/10

How many arguments does =MONTH have in total?

Question 7 of 10 7/10

Which function is related to =MONTH?

Question 8 of 10 8/10

Is =MONTH volatile?

Question 9 of 10 9/10

Is argument “serial_number” required in =MONTH?

Question 10 of 10 10/10

In =MONTH, which is argument #1?

Click a question to see the answer.

1. Which is the correct syntax of =MONTH?

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

Explanation: Correct syntax: =MONTH(serial_number)

2. Which statement about =MONTH 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. 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.
C. Select entire column for best performance
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.

3. What is the output type of =MONTH?

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

Explanation: Output is “Number”.

4. Does =MONTH return a dynamic array?

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

Explanation: MONTH does not spill.

5. Which category does =MONTH belong to?

A. Web
B. Database
C. Date & Time ✓
D. Lookup & Reference

Explanation: Category is “Date & Time”.

6. How many arguments does =MONTH have in total?

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

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

7. Which function is related to =MONTH?

A. REPLACE
B. COMBINA
C. DURATION
D. DATE ✓

Explanation: “DATE” is related to MONTH.

8. Is =MONTH volatile?

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

Explanation: MONTH is not volatile.

9. Is argument “serial_number” required in =MONTH?

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

Explanation: “serial_number” is required.

10. In =MONTH, which is argument #1?

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

Explanation: Argument #1 is “serial_number”.