In Excel, which function returns the number of days between two dates? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the number of days between two dates?

A. Both A and C

B. DAYS()

C. DATEDIF()

D. NETWORKDAYS()

Answer: Option A

Solution (By JKSSB Mock Tests)

DAYS(end, start) returns days. DATEDIF(start, end, "d") also returns days. NETWORKDAYS returns workdays.

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 Excel, what is the intersection of a row and a column called?

A. Cell

B. Range

C. Field

D. Record

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A cell is the intersection point. Range is a group of cells.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, a 'Table' object stores data in:

A. Forms

B. Reports

C. Rows (records) and columns (fields)

D. Pages

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Table structure is rows and columns.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following is NOT a valid type of section break in MS Word?

A. Even Page

B. Same Page

C. Next Page

D. Odd Page

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Section break types: Next Page, Continuous, Even Page, Odd Page.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs