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

B. TODAY()

C. DATE()

D. TIME()

Answer: Option A

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

Share Report

In PowerPoint, which of the following views displays a small image of each slide with its transition and timing?

A. Outline view

B. Reading view

C. Normal view

D. Slide Sorter view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Slide Sorter shows thumbnails and can display transition icons and timings below slides.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, what does the 'WEEKNUM' function return?

A. The day of the week

B. The weekday name

C. The week number of a date in the year

D. The number of weeks in a year

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
WEEKNUM returns the week number (1-53) for a given date. WEEKDAY returns the day of the week as a number.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

The shortcut to insert a hyperlink in MS Excel is:

A. Ctrl + J

B. Ctrl + K

C. Ctrl + L

D. Ctrl + H

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+K inserts hyperlink in Excel, Word, PowerPoint.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs