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

Question

Share Report Error

In Excel, which function returns the current date and time?

A. TIME()

B. DATE()

C. NOW()

D. TODAY()

Answer: Option C

Solution (By JKSSB Mock Tests)

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

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 Excel, the 'Transpose' paste option:

A. Pastes as a link

B. Switches rows to columns and columns to rows

C. Pastes formatting only

D. Copies only values

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Transpose changes data orientation.

This question belongs to: Computer Microsoft Office

Question #2

Which function in MS Excel calculates the number of cells within a specified range that contain any type of information, including text, errors, or numeric digits?

A. COUNTA

B. COUNTIF

C. COUNTBLANK

D. COUNT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The COUNTA function counts all non-empty cells within a range, regardless of whether they contain numbers, text, or errors. The COUNT function counts cells with numbers only.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, to quickly sum a range of numbers, use the shortcut:

A. Alt + Shift + =

B. Ctrl + Shift + $

C. Ctrl + +

D. Alt + =

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Alt + = inserts the AutoSum function.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs