What will be the output of the MS Excel formula =NETWORKDAYS(DATE(2026,6,15), DATE(2026,6,19)) if there are no holidays during this period? MCQ with Answer and Explanation

What will be the output of the MS Excel formula =NETWORKDAYS(DATE(2026,6,15), DATE(2026,6,19)) if there are no holidays during this period?
A. 4
B. #VALUE!
C. 3
D. 5
Answer: Option D
Solution (By JKSSB Mock Tests)
The NETWORKDAYS function calculates the number of working days (Monday through Friday) between two dates, inclusive of both start and end dates. June 15, 2026 (Monday) to June 19, 2026 (Friday) is exactly 5 business days.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In PowerPoint, 'Embed fonts' option is available under:
A. View -> Slide Master
B. Insert -> Text -> Font
C. Design -> Fonts
D. File -> Options -> Save

Correct Answer: Option D


Explanation:
Embed fonts is in PowerPoint Options, Save section.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, the function =VLOOKUP(102, A2:C10, 2, FALSE) searches for 102 in:
A. The row 102
B. The first column of the range A2:C10
C. The second column
D. The entire range

Correct Answer: Option B


Explanation:
VLOOKUP searches the first column of the table_array.

This question belongs to: Computer Microsoft Office
Question #3
Which section reference indicator in MS Word is placed at the absolute trailing end of an entire document file to compile long-form reference bibliography source origins?
A. Caption citation
B. Footnote
C. Header line text
D. Endnote

Correct Answer: Option D


Explanation:
Endnotes compile at the very end of a document or section block to document source citations. Footnotes appear at the bottom margin of the page where the reference was cited.

This question belongs to: Computer Microsoft Office