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. =NOW()

B. =TIME()

C. =TODAY()

D. =CURRENTTIME()

Answer: Option A

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

In MS Word, to view two parts of a document simultaneously, use:

A. Window -> New Window

B. Both A and B

C. View -> Split

D. Review -> Compare

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Split divides one window into two panes; New Window opens a second window of same document.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function calculates the number of cells that contain numbers in a range?

A. COUNTIF()

B. SUM()

C. COUNTA()

D. COUNT()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
COUNT counts numeric cells. COUNTA counts non-empty cells of any type.

This question belongs to: Computer Microsoft Office

Question #3

Which MS Excel tool lets you import raw text file lines and split them across multiple distinct worksheet columns using a delimiter like a comma or tab?

A. Text to Columns

B. Flash Fill

C. Data Validation

D. Merge Cells

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The 'Text to Columns' wizard splits text strings from a single cell across multiple columns using defined delimiters or fixed character widths.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs