In Excel, which function returns the serial number of the date that is a specified number of months before or after a start date? MCQ with Answer and Explanation

Question

In Excel, which function returns the serial number of the date that is a specified number of months before or after a start date?

A. MONTH()

B. EOMONTH()

C. EDATE()

D. DATE()

Answer: Option C

Solution (By JKSSB Mock Tests)

EDATE(start_date, months) shifts date by months.

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

Share Report

Which feature in Excel restricts the type of data that can be entered into a cell?

A. Goal Seek

B. Protect Sheet

C. Conditional Formatting

D. Data Validation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Data Validation controls allowed inputs (e.g., whole numbers, lists). Conditional Formatting changes appearance, Goal Seek performs what-if analysis, Protect Sheet restricts editing.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to calculate the net present value?

A. FV

B. IRR

C. PV

D. NPV

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
NPV calculates net present value.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the primary difference between a 'Save' and 'Save As' command sequence in MS Office programs?

A. 'Save' completely locks down file text permissions automatically.

B. There is no difference in modern 2026 software versions.

C. 'Save As' can only overwrite data lines on cloud folders.

D. 'Save' updates an existing file; 'Save As' allows you to save the file with a new name, format, or location.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Save command saves changes to the current file name. Save As prompts for a new file name, location, or format file extension type.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs