In Excel, which function is used to return the current time? MCQ with Answer and Explanation

In Excel, which function is used to return the current time?
A. =TODAY()
B. =NOW()
C. =TIME()
D. =CURRENTTIME()
Answer: Option B
Solution (By JKExamLibrary)
NOW() returns date and time. TIME() creates a time from given hours, minutes, seconds. There is no CURRENTTIME.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which command is used to remove all manual character formatting in Word?
A. Ctrl + Spacebar
B. Ctrl + Shift + Z
C. Ctrl + Shift + N
D. Ctrl + Q

Correct Answer: Option A


Explanation:
Ctrl + Spacebar clears character formatting (font, size, etc.). Ctrl + Q clears paragraph formatting.

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, which of the following is used to create a user interface for data entry?
A. Report
B. Macro
C. Query
D. Form

Correct Answer: Option D


Explanation:
Forms are the primary interface for data entry and editing. Reports are for output, queries for data retrieval, macros for automation.

This question belongs to: Computer Microsoft Office
Question #3
Which of the following is a type of animation in PowerPoint?
A. Slide Master
B. Design Template
C. Slide Transition
D. Motion Paths

Correct Answer: Option D


Explanation:
Motion Paths are animation effects for objects. Transition is not an animation category.

This question belongs to: Computer Microsoft Office