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

Which category does =MONTH belong to?

Question 2 of 15 2/15

Since which Excel version is =MONTH available?

Question 3 of 15 3/15

Which function is related to =MONTH?

Question 4 of 15 4/15

How many required arguments does =MONTH have?

Question 5 of 15 5/15

How many optional arguments does =MONTH have?

Question 6 of 15 6/15

Which statement about =MONTH is correct?

Question 7 of 15 7/15

How many arguments does =MONTH have in total?

Question 8 of 15 8/15

In =MONTH, which is argument #1?

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

Does =MONTH return a dynamic array?

Question 12 of 15 12/15

Which use case fits =MONTH?

Question 13 of 15 13/15

Is =MONTH volatile?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Which function is NOT related to =MONTH?

Click a question to see the answer.

1. Which category does =MONTH belong to?

A. Cube
B. Compatibility
C. Financial
D. Date & Time ✓

Explanation: Category is “Date & Time”.

2. Since which Excel version is =MONTH available?

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

Explanation: Version: “All versions”.

3. Which function is related to =MONTH?

A. VAR.P
B. BETA.INV
C. MAXA
D. DATE ✓

Explanation: “DATE” is related to MONTH.

4. How many required arguments does =MONTH have?

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

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

5. How many optional arguments does =MONTH have?

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

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

6. 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. Text is always ignored
C. Requires add-in
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.

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

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

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

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

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

Explanation: Argument #1 is “serial_number”.

9. Which is the correct syntax of =MONTH?

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

Explanation: Correct syntax: =MONTH(serial_number)

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

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

Explanation: “serial_number” is required.

11. Does =MONTH return a dynamic array?

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

Explanation: MONTH does not spill.

12. Which use case fits =MONTH?

A. Investment Appraisal
B. Date & Time Calculations ✓
C. Numbering & Sample Data
D. Ranking & Top N

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

13. Is =MONTH volatile?

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

Explanation: MONTH is not volatile.

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

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

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

15. Which function is NOT related to =MONTH?

A. RANK.EQ ✓
B. DATE
C. TEXT
D. DAY

Explanation: “RANK.EQ” is not related to MONTH.