In Excel, which function returns the current date and time? MCQ with Answer and Explanation

In Excel, which function returns the current date and time?
A. TIME()
B. TODAY()
C. DATE()
D. NOW()
Answer: Option D
Solution (By JKExamLibrary)
NOW() returns serial number of current date and time. TODAY() returns date only. DATE(year,month,day) constructs a date.

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 MS PowerPoint, which tool captures precise rehearsed presentation loops, recording how long slides run to help automate slide presentation delivery timelines?
A. Slide Sorter setup
B. Presenter Coach dashboard
C. Animation Painter tool
D. Rehearse Timings

Correct Answer: Option D


Explanation:
The Rehearse Timings feature launches full-screen slide delivery with an on-screen timer to track slide durations, saving those timestamps to automate future playback.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What is the shortcut key to open the 'Symbol' dialog in MS Word?
A. Both A and B
B. Alt + Ctrl + S
C. Insert > Symbol
D. Alt + N, U, S

Correct Answer: Option A


Explanation:
You can insert symbol via Insert > Symbol, and the keyboard shortcut Alt+N,U,S (or Alt+I,S in older versions) opens the Symbol dialog. So both are valid.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
Which pane in MS PowerPoint allows authors to manage the playback sequence, timings, delays, and trigger rules of individual slide animations?
A. Format Background properties sheet
B. Selection Pane
C. Transition Configuration panel
D. Animation Pane

Correct Answer: Option D


Explanation:
The Animation Pane opens on the right side of the workspace, providing a timeline layout to view, reorder, adjust timings, and configure triggers for all animations on the slide.

This question belongs to: Computer Microsoft Office