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

Question

Share Report Error

In Excel, which function is used to return the current time?

A. =TIME()

B. =TODAY()

C. =CURRENTTIME()

D. =NOW()

Answer: Option D

Solution (By JKSSB Mock Tests)

NOW() returns date and time. TIME() creates a time from given hours, minutes, seconds. There is no CURRENTTIME.

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

Share Report

What type of special validation error alert is thrown by MS Excel if a formula includes an invalid numeric argument or out-of-bounds parameter, such as finding the square root of a negative number via =SQRT(-9)?

A. #DIV/0!

B. #NAME?

C. #NUM!

D. #VALUE!

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The #NUM! error indicates a problem with a number in a formula, such as an argument that falls outside a function's supported domain (e.g., performing a square root on a negative number).

This question belongs to: Computer Microsoft Office