Date & Time =EOMONTH(start_date, months)

Quiz =EOMONTH — 15 Questions

15 quiz questions about =EOMONTH — test syntax, arguments, examples & errors!

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

← EOMONTH ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is =EOMONTH volatile?

Question 2 of 15 2/15

In =EOMONTH, which is argument #1?

Question 3 of 15 3/15

Which function is related to =EOMONTH?

Question 4 of 15 4/15

Is argument “months” required in =EOMONTH?

Question 5 of 15 5/15

Since which Excel version is =EOMONTH available?

Question 6 of 15 6/15

Is argument “start_date” required in =EOMONTH?

Question 7 of 15 7/15

Which category does =EOMONTH belong to?

Question 8 of 15 8/15

Which is the correct syntax of =EOMONTH?

Question 9 of 15 9/15

Which formula is a valid example of =EOMONTH?

Question 10 of 15 10/15

How many arguments does =EOMONTH have in total?

Question 11 of 15 11/15

Does =EOMONTH return a dynamic array?

Question 12 of 15 12/15

Which statement about =EOMONTH is correct?

Question 13 of 15 13/15

What is the type of argument “months” in =EOMONTH?

Question 14 of 15 14/15

How many required arguments does =EOMONTH have?

Question 15 of 15 15/15

In =EOMONTH, which is argument #2?

Click a question to see the answer.

1. Is =EOMONTH volatile?

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

Explanation: EOMONTH is not volatile.

2. In =EOMONTH, which is argument #1?

A. value
B. criteria
C. lookup_value
D. start_date ✓

Explanation: Argument #1 is “start_date”.

3. Which function is related to =EOMONTH?

A. DAY ✓
B. EXPONDIST
C. LOOKUP
D. GCD

Explanation: “DAY” is related to EOMONTH.

4. Is argument “months” required in =EOMONTH?

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

Explanation: “months” is required.

5. Since which Excel version is =EOMONTH available?

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

Explanation: Version: “All versions”.

6. Is argument “start_date” required in =EOMONTH?

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

Explanation: “start_date” is required.

7. Which category does =EOMONTH belong to?

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

Explanation: Category is “Date & Time”.

8. Which is the correct syntax of =EOMONTH?

A. EOMONTH(start_date, months)
B. =EOMONTH(start_date, months) ✓
C. =EOMONTH(start_date, months, 0)
D. =DAY(start_date, months)

Explanation: Correct syntax: =EOMONTH(start_date, months)

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

A. EOMONTH(A2,1)
B. =EOMONTH(A2,1) ✓
C. =EOMONTH(A2,1, 0)
D. =DAY(A2,1)

Explanation: Correct example: =EOMONTH(A2,1)

10. How many arguments does =EOMONTH have in total?

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

Explanation: =EOMONTH has 2 required, 0 optional (2 total).

11. Does =EOMONTH return a dynamic array?

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

Explanation: EOMONTH does not spill.

12. Which statement about =EOMONTH is correct?

A. Output is always a dynamic array
B. Text is always ignored
C. Only works in old versions
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.

13. What is the type of argument “months” in =EOMONTH?

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

Explanation: Type of “months” is “Number”.

14. How many required arguments does =EOMONTH have?

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

Explanation: =EOMONTH has 2 required, 0 optional (2 total).

15. In =EOMONTH, which is argument #2?

A. criteria
B. lookup_value
C. months ✓
D. start_date

Explanation: Argument #2 is “months”.