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 argument “start_date” required in =EOMONTH?

Question 2 of 15 2/15

Is =EOMONTH volatile?

Question 3 of 15 3/15

Which formula is a valid example of =EOMONTH?

Question 4 of 15 4/15

How many required arguments does =EOMONTH have?

Question 5 of 15 5/15

Which category does =EOMONTH belong to?

Question 6 of 15 6/15

Which statement about =EOMONTH is correct?

Question 7 of 15 7/15

In =EOMONTH, which is argument #2?

Question 8 of 15 8/15

Which is the correct syntax of =EOMONTH?

Question 9 of 15 9/15

Since which Excel version is =EOMONTH available?

Question 10 of 15 10/15

In =EOMONTH, which is argument #1?

Question 11 of 15 11/15

Which function is NOT related to =EOMONTH?

Question 12 of 15 12/15

Which function is related to =EOMONTH?

Question 13 of 15 13/15

What is the output type of =EOMONTH?

Question 14 of 15 14/15

How many arguments does =EOMONTH have in total?

Question 15 of 15 15/15

Is argument “months” required in =EOMONTH?

Click a question to see the answer.

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

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

Explanation: “start_date” is required.

2. Is =EOMONTH volatile?

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

Explanation: EOMONTH is not volatile.

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

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

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

4. How many required arguments does =EOMONTH have?

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

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

5. Which category does =EOMONTH belong to?

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

Explanation: Category is “Date & Time”.

6. Which statement about =EOMONTH 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. Volatile and recalculates every time
C. Select entire column for best performance
D. Only works in old versions

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. In =EOMONTH, which is argument #2?

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

Explanation: Argument #2 is “months”.

8. Which is the correct syntax of =EOMONTH?

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

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

9. Since which Excel version is =EOMONTH available?

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

Explanation: Version: “All versions”.

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

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

Explanation: Argument #1 is “start_date”.

11. Which function is NOT related to =EOMONTH?

A. EDATE
B. TRUE ✓
C. DAY
D. DATE

Explanation: “TRUE” is not related to EOMONTH.

12. Which function is related to =EOMONTH?

A. DAY ✓
B. PRICE
C. CRITBINOM
D. HEX2OCT

Explanation: “DAY” is related to EOMONTH.

13. What is the output type of =EOMONTH?

A. Value
B. Mixed
C. Date ✓
D. Logical

Explanation: Output is “Date”.

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

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

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

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

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

Explanation: “months” is required.