In Excel, which function is used to calculate the number of days between two dates? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the number of days between two dates?

A. NETWORKDAYS

B. All of the above

C. DATEDIF

D. DAYS

Answer: Option B

Solution (By JKSSB Mock Tests)

DAYS, DATEDIF, and NETWORKDAYS all can calculate days between dates (NETWORKDAYS counts working days). So all are valid.

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

What does the shortcut Ctrl + H do in MS Word?

A. Applies highlighting

B. Opens the Replace dialog box

C. Opens the Find dialog

D. Hides the selected text

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + H opens Find and Replace with Replace tab active.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, the formula =INDEX(A1:C3, 2, 3) will return the value from:

A. Second row, third column of the range A1:C3

B. Cell B2

C. Third row, second column

D. An error

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
INDEX(array, row_num, col_num) returns the value at intersection. 2nd row, 3rd column is cell C2.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function is used to calculate the depreciation of an asset using the straight-line method?

A. SYD

B. SLN

C. DDB

D. DB

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SLN returns straight-line depreciation. SYD is sum-of-years digits, DDB double-declining balance, DB fixed declining.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs