Date & Time =EOMONTH(start_date, months)

Quiz =EOMONTH — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Which is the correct syntax of =EOMONTH?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

What is the output type of =EOMONTH?

Question 4 of 10 4/10

In =EOMONTH, which is argument #2?

Question 5 of 10 5/10

Which function is related to =EOMONTH?

Question 6 of 10 6/10

Since which Excel version is =EOMONTH available?

Question 7 of 10 7/10

Is argument “months” required in =EOMONTH?

Question 8 of 10 8/10

What is the fix for #NUM! in =EOMONTH?

Question 9 of 10 9/10

Is argument “start_date” required in =EOMONTH?

Question 10 of 10 10/10

Which statement about =EOMONTH is correct?

Click a question to see the answer.

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

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

A. Number
B. Date ✓
C. Text
D. Mixed

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

3. What is the output type of =EOMONTH?

A. Logical
B. Date ✓
C. Number
D. Reference

Explanation: Output is “Date”.

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

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

Explanation: Argument #2 is “months”.

5. Which function is related to =EOMONTH?

A. DVAR
B. SKEW.P
C. DPRODUCT
D. DAY ✓

Explanation: “DAY” is related to EOMONTH.

6. Since which Excel version is =EOMONTH available?

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

Explanation: Version: “All versions”.

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

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

Explanation: “months” is required.

8. What is the fix for #NUM! in =EOMONTH?

A. Output is always a dynamic array
B. Requires add-in
C. تاریخ شروع را با تابع DATE وارد کنید و مقدار months را طوری انتخاب کنید که تاریخ حاصل در محدوده مجاز اکسل باشد. ✓
D. Volatile and recalculates every time

Explanation: If start_date is not a valid date, EOMONTH returns the #NUM! error value. If start_date plus months yields an invalid date, EOMONTH returns the #NUM! error value. — Fix: تاریخ شروع را با تابع DATE وارد کنید و مقدار months را طوری انتخاب کنید که تاریخ حاصل در محدوده مجاز اکسل باشد.

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

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

Explanation: “start_date” is required.

10. Which statement about =EOMONTH is correct?

A. Text is always ignored
B. Select entire column for best performance
C. 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. ✓
D. Requires add-in

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.