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

B. =DATE()

C. =NOW()

D. =CURRENTDATE()

Answer: Option A

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, to quickly sum a range of numbers, use the shortcut:

A. Alt + =

B. Ctrl + +

C. Alt + Shift + =

D. Ctrl + Shift + $

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt + = inserts the AutoSum function.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, the 'Caption' property is used to:

A. Define the input mask

B. Set the field size

C. Set the label displayed for the field in forms and reports

D. Set the default value

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Caption provides an alternate name for the field for display.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, a 'Navigation form' is used to:

A. Create tables

B. Provide a menu system to open forms and reports

C. Print reports

D. Enter data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Navigation form acts as a switchboard.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs