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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
Which category does =MONTH belong to?
Explanation: Category is “Date & Time”.
Question 2 of 10
2/10
Does =MONTH return a dynamic array?
Explanation: MONTH does not spill.
Question 3 of 10
3/10
Which formula is a valid example of =MONTH?
Explanation: Correct example: =MONTH(A2)
Question 4 of 10
4/10
Which statement about =MONTH is correct?
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.
Question 5 of 10
5/10
Since which Excel version is =MONTH available?
Explanation: Version: “All versions”.
Question 6 of 10
6/10
Which is the correct syntax of =MONTH?
Explanation: Correct syntax: =MONTH(serial_number)
Question 7 of 10
7/10
Which function is related to =MONTH?
Explanation: “DATE” is related to MONTH.
Question 8 of 10
8/10
What is the type of argument “serial_number” in =MONTH?
Explanation: Type of “serial_number” is “Any type”.
Question 9 of 10
9/10
Which use case fits =MONTH?
Explanation: Use case “Date & Time Calculations” fits MONTH.
Question 10 of 10
10/10
How many required arguments does =MONTH have?
Explanation: =MONTH has 1 required, 0 optional (1 total).