In Excel, which function is used to return the number of whole workdays between two dates (excluding weekends and holidays)? MCQ with Answer and Explanation

Question

In Excel, which function is used to return the number of whole workdays between two dates (excluding weekends and holidays)?

A. DAYS()

B. WORKDAY()

C. DATEDIF()

D. NETWORKDAYS()

Answer: Option D

Solution (By JKSSB Mock Tests)

NETWORKDAYS returns workdays. WORKDAY returns a date after number of 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, the 'Thesaurus' command is under which group in the Review tab?

A. Proofing

B. Language

C. Comments

D. Tracking

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Thesaurus is in the Proofing group along with Spelling & Grammar, Word Count, etc.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key sequence to toggle selected text between Uppercase, Lowercase, and Title Case in MS Word?

A. Alt + F3

B. Shift + F3

C. Ctrl + Shift + A

D. Ctrl + F3

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Pressing Shift + F3 rotates the casing of the highlighted text selection through UPPERCASE, lowercase, and Capitalize Each Word.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, which of the following is an example of an action query?

A. Select query

B. Update query

C. Parameter query

D. Crosstab query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Action queries: Update, Delete, Append, Make-Table.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs