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

Question 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 JKExamLibrary)

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

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error

To select the entire row in Excel, press:

A. Ctrl + Spacebar

B. Alt + Spacebar

C. Ctrl + Shift + Spacebar

D. Shift + Spacebar

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Shift+Spacebar selects the entire row. Ctrl+Spacebar selects entire column.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS PowerPoint, which of the following is used to insert a table with a specific number of rows and columns?

A. Insert > Table > Draw Table

B. Insert > Table > Insert Table

C. Insert > Table > Quick Tables

D. Insert > Table > Excel Spreadsheet

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Insert Table dialog lets you specify rows and columns.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

What is the shortcut to maximize a document window in MS Word?

A. F11

B. Ctrl + F10

C. Ctrl + F12

D. Alt + F10

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Ctrl+F10 maximizes document window.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs