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

Which use case fits =EOMONTH?

Question 2 of 15 2/15

Is =EOMONTH volatile?

Question 3 of 15 3/15

What is the output type of =EOMONTH?

Question 4 of 15 4/15

Which is the correct syntax of =EOMONTH?

Question 5 of 15 5/15

How many optional arguments does =EOMONTH have?

Question 6 of 15 6/15

Which formula is a valid example of =EOMONTH?

Question 7 of 15 7/15

Which function is related to =EOMONTH?

Question 8 of 15 8/15

Which statement about =EOMONTH is correct?

Question 9 of 15 9/15

Is argument “months” required in =EOMONTH?

Question 10 of 15 10/15

Which category does =EOMONTH belong to?

Question 11 of 15 11/15

How many required arguments does =EOMONTH have?

Question 12 of 15 12/15

Which function is NOT related to =EOMONTH?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Since which Excel version is =EOMONTH available?

Question 15 of 15 15/15

Is argument “start_date” required in =EOMONTH?

Click a question to see the answer.

1. Which use case fits =EOMONTH?

A. Conditional Formatting & Validation
B. Numbering & Sample Data
C. Financial Calculations
D. Daily Tasks ✓

Explanation: Use case “Daily Tasks” fits EOMONTH.

2. Is =EOMONTH volatile?

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

Explanation: EOMONTH is not volatile.

3. What is the output type of =EOMONTH?

A. Text
B. Value
C. Date ✓
D. Reference

Explanation: Output is “Date”.

4. 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)

5. How many optional arguments does =EOMONTH have?

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

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

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

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

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

7. Which function is related to =EOMONTH?

A. FVSCHEDULE
B. ISERROR
C. MATCH
D. DAY ✓

Explanation: “DAY” is related to EOMONTH.

8. 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. Text is always ignored
C. Only works in old versions
D. Volatile and recalculates every time

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.

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

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

Explanation: “months” is required.

10. Which category does =EOMONTH belong to?

A. Date & Time ✓
B. Lookup & Reference
C. Engineering
D. Compatibility

Explanation: Category is “Date & Time”.

11. How many required arguments does =EOMONTH have?

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

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

12. Which function is NOT related to =EOMONTH?

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

Explanation: “BITXOR” is not related to EOMONTH.

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

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

Explanation: Type of “start_date” is “Date”.

14. Since which Excel version is =EOMONTH available?

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

Explanation: Version: “All versions”.

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

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

Explanation: “start_date” is required.