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

D. DATEDIF()

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

Share Report

In MS Word, which of the following is an example of a font style or character decoration attribute?

A. Strikethrough

B. Calibri

C. Margins

D. 12 pt

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Strikethrough is an explicitly selectable character effect attribute, whereas Calibri is a font family, and 12 pt represents font size metric sizing.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to calculate the exponential growth?

A. TREND

B. LOG

C. GROWTH

D. EXP

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
GROWTH calculates exponential growth based on existing data. EXP returns e raised to a power, LOG is logarithm, TREND for linear trend.

This question belongs to: Computer Microsoft Office