In Excel, which function returns the number of days between two dates? MCQ with Answer and Explanation

In Excel, which function returns the number of days between two dates?
A. DATEDIF()
B. NETWORKDAYS()
C. Both A and C
D. DAYS()
Answer: Option C
Solution (By JKSSB Mock Tests)
DAYS(end, start) returns days. DATEDIF(start, end, "d") also returns days. NETWORKDAYS returns workdays.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which feature in MS PowerPoint allows you to pick an active application window on your desktop and insert a static snapshot image of it directly onto a slide?
A. Screen Recording video
B. Cameo live video stream
C. SmartArt graphic layout
D. Screenshot

Correct Answer: Option D


Explanation:
The Screenshot tool captures a static image snapshot of any open window on your desktop and embeds it directly onto the active presentation slide.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, the shortcut to apply normal style is:
A. Alt + Shift + N
B. Ctrl + Alt + N
C. Ctrl + Shift + N
D. Ctrl + N

Correct Answer: Option C


Explanation:
Ctrl+Shift+N applies Normal style.

This question belongs to: Computer Microsoft Office
Question #3
Which shortcut key is used to center align text in MS Word?
A. Ctrl + E
B. Ctrl + J
C. Ctrl + R
D. Ctrl + L

Correct Answer: Option A


Explanation:
Ctrl+E centres, Ctrl+L left, Ctrl+R right, Ctrl+J justify.

This question belongs to: Computer Microsoft Office