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

Question

Share Report Error

In Excel, which function returns the current date only (no time)?

A. NOW()

B. TODAY()

C. DAY()

D. DATE()

Answer: Option B

Solution (By JKSSB Mock Tests)

TODAY() returns date. NOW() returns date and time.

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 Excel, which function is used to join text from multiple cells with a delimiter (Excel 2019/365)?

A. TEXTJOIN()

B. CONCAT()

C. CONCATENATE()

D. JOIN()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
TEXTJOIN has a delimiter argument. CONCAT does not have delimiter.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, which data type automatically inserts a unique sequential number?

A. Number

B. AutoNumber

C. Calculated

D. Text

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
AutoNumber increments automatically.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, 'Shrink One Page' command attempts to:

A. Reduce the document by one page by adjusting font size and spacing

B. Zoom out

C. Print the document on one page

D. Delete the last page

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Shrink One Page (Print Preview) reduces content to fit one less page.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs