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

Is =MONTH volatile?

Question 2 of 15 2/15

How many optional arguments does =MONTH have?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which use case fits =MONTH?

Question 5 of 15 5/15

Which function is related to =MONTH?

Question 6 of 15 6/15

Which is the correct syntax of =MONTH?

Question 7 of 15 7/15

How many required arguments does =MONTH have?

Question 8 of 15 8/15

Since which Excel version is =MONTH available?

Question 9 of 15 9/15

Which formula is a valid example of =MONTH?

Question 10 of 15 10/15

Which category does =MONTH belong to?

Question 11 of 15 11/15

Which function is NOT related to =MONTH?

Question 12 of 15 12/15

In =MONTH, which is argument #1?

Question 13 of 15 13/15

Is argument “serial_number” required in =MONTH?

Question 14 of 15 14/15

What is the output type of =MONTH?

Question 15 of 15 15/15

Which statement about =MONTH is correct?

Click a question to see the answer.

1. Is =MONTH volatile?

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

Explanation: MONTH is not volatile.

2. How many optional arguments does =MONTH have?

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

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

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

A. Any type ✓
B. Value
C. Mixed
D. Reference

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

4. Which use case fits =MONTH?

A. Scientific & Unit Conversion
B. Reshape Tables
C. Worksheet Info & Navigation
D. Date & Time Calculations ✓

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

5. Which function is related to =MONTH?

A. DATE ✓
B. TRUE
C. BIN2HEX
D. LOGNORM.INV

Explanation: “DATE” is related to MONTH.

6. Which is the correct syntax of =MONTH?

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

Explanation: Correct syntax: =MONTH(serial_number)

7. How many required arguments does =MONTH have?

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

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

8. Since which Excel version is =MONTH available?

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

Explanation: Version: “All versions”.

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

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

Explanation: Correct example: =MONTH(A2)

10. Which category does =MONTH belong to?

A. Financial
B. Date & Time ✓
C. Statistical
D. Lookup & Reference

Explanation: Category is “Date & Time”.

11. Which function is NOT related to =MONTH?

A. DAY
B. TEXTAFTER ✓
C. DATE
D. TEXT

Explanation: “TEXTAFTER” is not related to MONTH.

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

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

Explanation: Argument #1 is “serial_number”.

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

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

Explanation: “serial_number” is required.

14. What is the output type of =MONTH?

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

Explanation: Output is “Number”.

15. 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. Select entire column for best performance
C. 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.
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.