In Excel, which function returns the number of days in a month? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the number of days in a month?

A. EDATE()

B. EOMONTH() with DAY()

C. MONTH()

D. DAYSINMONTH()

Answer: Option B

Solution (By JKSSB Mock Tests)

There is no direct function; you can use =DAY(EOMONTH(date,0)).

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In MS PowerPoint, what is the action or function of the shortcut 'Ctrl + M'?

A. Minimizes the interface

B. Inserts a new blank slide

C. Saves the file

D. Opens a new window

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In MS PowerPoint, Ctrl + M inserts a new slide into the active presentation, while Ctrl + N opens a brand-new blank file.

This question belongs to: Computer Microsoft Office

Question #2

What will be the output of the MS Excel formula =NETWORKDAYS(DATE(2026,6,15), DATE(2026,6,19)) if there are no holidays during this period?

A. 5

B. 3

C. #VALUE!

D. 4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The NETWORKDAYS function calculates the number of working days (Monday through Friday) between two dates, inclusive of both start and end dates. June 15, 2026 (Monday) to June 19, 2026 (Friday) is exactly 5 business days.

This question belongs to: Computer Microsoft Office

Question #3

What is the shortcut key to start a slideshow from the beginning in MS PowerPoint?

A. Shift + F5

B. F5

C. Alt + F5

D. Ctrl + F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F5 starts the slideshow from the first slide. Shift + F5 starts from the current slide. Ctrl+F5 is not standard.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs