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. WORKDAY()
B. DAYS()
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
Which view mode in MS Word is designed specifically to optimize long-form document reading by replacing edit menus with simple tracking arrows?
A. Read Mode
B. Outline View
C. Web Layout
D. Draft View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Read Mode hides editing tools and rearranges document flow into side-by-side horizontal cards for easy reading.
This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, which option is used to add a slide background picture?
A. Design > Background Styles
B. Insert > Picture
C. Format Background > Picture or texture fill
D. Both A and C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
You can set a background picture via Format Background (right-click slide) or via Design > Background Styles > Format Background. Both lead to the same pane.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which object is used to present data in a printed format with headers, footers, and grouping?
A. Table
B. Query
C. Report
D. Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Reports are designed for printing and often include grouping and summaries.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?