In Excel, the function =NETWORKDAYS(start, end) returns: MCQ with Answer and Explanation

Question Report Error

In Excel, the function =NETWORKDAYS(start, end) returns:

A. Total days between dates

B. Days including holidays

C. Number of working days (excluding weekends) between dates

D. Number of calendar days

Answer: Option C

Solution (By JKExamLibrary)

NETWORKDAYS excludes Saturdays and Sundays and optionally holidays.

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

In Excel, the function =COLUMN() in cell D5 returns:

A. 4

B. D

C. 5

D. Error

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Column D is 4th column.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Access, to add a calculated field in a query, you:

A. Both A and B

B. Use the Expression Builder in the Field row

C. Use the Append query

D. Type an expression in a blank column of the query design grid

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
You can type directly or use Expression Builder.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

Which view in MS Word helps to organize and navigate a long document using headings?

A. Draft view

B. Read Mode

C. Web Layout

D. Outline view

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Outline view shows the document's structure based on heading levels, allowing collapsing/expanding.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs