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

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

Question 2 of 10 2/10

Is argument “start_date” required in =EOMONTH?

Question 3 of 10 3/10

What is the output type of =EOMONTH?

Question 4 of 10 4/10

Does =EOMONTH return a dynamic array?

Question 5 of 10 5/10

Which is the correct syntax of =EOMONTH?

Question 6 of 10 6/10

How many optional arguments does =EOMONTH have?

Question 7 of 10 7/10

Which use case fits =EOMONTH?

Question 8 of 10 8/10

Is =EOMONTH volatile?

Question 9 of 10 9/10

What usually causes #NUM! in =EOMONTH?

Question 10 of 10 10/10

Which statement about =EOMONTH is correct?

Click a question to see the answer.

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

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

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

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

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

Explanation: “start_date” is required.

3. What is the output type of =EOMONTH?

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

Explanation: Output is “Date”.

4. Does =EOMONTH return a dynamic array?

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

Explanation: EOMONTH does not spill.

5. Which is the correct syntax of =EOMONTH?

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

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

6. How many optional arguments does =EOMONTH have?

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

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

7. Which use case fits =EOMONTH?

A. Conditional Formatting & Validation
B. Financial Calculations
C. Comparation
D. Daily Tasks ✓

Explanation: Use case “Daily Tasks” fits EOMONTH.

8. Is =EOMONTH volatile?

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

Explanation: EOMONTH is not volatile.

9. What usually causes #NUM! in =EOMONTH?

A. 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. ✓
B. Text is always ignored
C. Only works in old versions
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 را طوری انتخاب کنید که تاریخ حاصل در محدوده مجاز اکسل باشد.

10. Which statement about =EOMONTH is correct?

A. Select entire column for best performance
B. Text is always ignored
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. 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.