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. EDATE()

B. DATE()

C. MONTH()

D. EOMONTH()

Answer: Option A

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

What is the keyboard shortcut to apply a 1.5 line spacing format to a selected paragraph block in MS Word?

A. Ctrl + 5

B. Ctrl + Shift + 5

C. Ctrl + 1

D. Ctrl + 2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In MS Word, the paragraph spacing shortcuts are: Ctrl + 1 for single spacing, Ctrl + 2 for double spacing, and Ctrl + 5 for 1.5 line spacing.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which action query type in MS Access copies selected data rows from one or more existing source tables and creates a brand-new table with those records?

A. Crosstab Query

B. Make-Table Query

C. Update Query

D. Append Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Make-Table Query extracts specific records from existing source fields and uses them to create a brand-new table in the database file.

This question belongs to: Computer Microsoft Office