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

D. NOW()

Answer: Option D

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 MS Access, the 'Validation Text' property is used to:

A. Format the field

B. Define the input mask

C. Display a custom error message when the validation rule is violated

D. Set the default value

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Validation Text provides a message.

This question belongs to: Computer Microsoft Office

Question #2

What is the shortcut key to select all content in MS Office?

A. Alt + A

B. Ctrl + E

C. Ctrl + Shift + A

D. Ctrl + A

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+A selects all.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which chart type is used to show the proportion of parts to a whole?

A. Bar Chart

B. Pie Chart

C. Area Chart

D. Line Chart

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Pie charts are used to display parts of a whole as percentages. Bar and column compare categories, line shows trends, area similar to line with filled area.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs