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

Question

Share Report Error

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

A. Total days between dates

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

C. Days including holidays

D. Number of calendar days

Answer: Option B

Solution (By JKSSB Mock Tests)

NETWORKDAYS excludes Saturdays and Sundays and optionally holidays.

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

In MS Access, a 'Query' can be used to:

A. Generate reports

B. Create relationships

C. Create forms

D. Add, delete, or update data in tables

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Queries can be action queries that add, delete, update, or append data. Forms are created separately, reports separately, and relationships are defined in the Relationships window.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, what is the default paragraph alignment?

A. Justify

B. Left

C. Right

D. Centre

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Default alignment is left.

This question belongs to: Computer Microsoft Office

Question #3

What will be the output of the MS Excel formula =COUNTIF(A1:A4, >10) if cell entries are A1=5, A2=10, A3=15, and A4=20?

A. 3

B. 4

C. 1

D. 2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The formula filters for numbers strictly greater than 10. Out of the given values, 15 and 20 satisfy the condition, so the function returns 2.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs