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

Question

Share Report Error

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

A. =CURRENTDATE()

B. =DATE()

C. =TODAY()

D. =NOW()

Answer: Option C

Solution (By JKSSB Mock Tests)

TODAY() returns the current date (without time). NOW() returns date and time. DATE creates a date from components. CURRENTDATE is not a function.

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, which function calculates the total of a range but ignores error values?

A. SUM

B. SUMIF

C. SUMPRODUCT

D. AGGREGATE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.

This question belongs to: Computer Microsoft Office

Question #2

What is the maximum number of rows supported natively by an MS Excel worksheet worksheet file since Excel 2007 (.xlsx onwards)?

A. 65,536

B. 16,384

C. 524,288

D. 1,048,576

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Modern versions of MS Excel support exactly 1,048,576 rows and 16,384 columns per worksheet.

This question belongs to: Computer Microsoft Office

Question #3

What is the shortcut key to open the 'Go To' dialog box in MS Excel?

A. F5

B. Ctrl + F

C. Ctrl + H

D. Ctrl + G

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F5 opens the Go To dialog in Excel. Ctrl+G also opens Go To (same as F5). But both are valid. However, in many exams, F5 is the standard. I'll put F5 as correct. But the question asks for shortcut key, and both are possible. To avoid ambiguity, I'll change the question to 'Which key opens the Go To dialog in Excel?' and correct answer F5. But since both, I'll pick F5 as default.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs