Date & Time =MONTH(serial_number)

Quiz =MONTH — 15 Questions

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

Question 1 of 15 1/15

Does =MONTH return a dynamic array?

Question 2 of 15 2/15

What is the output type of =MONTH?

Question 3 of 15 3/15

In =MONTH, which is argument #1?

Question 4 of 15 4/15

Is =MONTH volatile?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Which category does =MONTH belong to?

Question 7 of 15 7/15

How many optional arguments does =MONTH have?

Question 8 of 15 8/15

Since which Excel version is =MONTH available?

Question 9 of 15 9/15

Which is the correct syntax of =MONTH?

Question 10 of 15 10/15

Is argument “serial_number” required in =MONTH?

Question 11 of 15 11/15

Which function is related to =MONTH?

Question 12 of 15 12/15

How many required arguments does =MONTH have?

Question 13 of 15 13/15

Which use case fits =MONTH?

Question 14 of 15 14/15

Which statement about =MONTH is correct?

Question 15 of 15 15/15

Which formula is a valid example of =MONTH?

Click a question to see the answer.

1. Does =MONTH return a dynamic array?

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

Explanation: MONTH does not spill.

2. What is the output type of =MONTH?

A. Text
B. Mixed
C. Number ✓
D. Array

Explanation: Output is “Number”.

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

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

Explanation: Argument #1 is “serial_number”.

4. Is =MONTH volatile?

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

Explanation: MONTH is not volatile.

5. What is the type of argument “serial_number” in =MONTH?

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

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

6. Which category does =MONTH belong to?

A. Date & Time ✓
B. Text
C. Database
D. Financial

Explanation: Category is “Date & Time”.

7. How many optional arguments does =MONTH have?

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

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

8. Since which Excel version is =MONTH available?

A. Excel 365
B. Excel 2019
C. Excel 2007 (Compatibility)
D. All versions ✓

Explanation: Version: “All versions”.

9. Which is the correct syntax of =MONTH?

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

Explanation: Correct syntax: =MONTH(serial_number)

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

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

Explanation: “serial_number” is required.

11. Which function is related to =MONTH?

A. TDIST
B. SUBTOTAL
C. PERCENTILE
D. DATE ✓

Explanation: “DATE” is related to MONTH.

12. How many required arguments does =MONTH have?

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

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

13. Which use case fits =MONTH?

A. Workdays & Due Dates
B. Text Manipulation
C. Date & Time Calculations ✓
D. Numbering & Sample Data

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

14. Which statement about =MONTH is correct?

A. 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.
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. Volatile and recalculates every time
D. Text is always ignored

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.

15. Which formula is a valid example of =MONTH?

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

Explanation: Correct example: =MONTH(A2)