Which MS Excel function returns the serial number of the current system date and time simultaneously? MCQ with Answer and Explanation

Question

Share Report Error

Which MS Excel function returns the serial number of the current system date and time simultaneously?

A. TODAY()

B. TIME()

C. DATE()

D. NOW()

Answer: Option D

Solution (By JKSSB Mock Tests)

The NOW() function returns both the current system date and time. In contrast, TODAY() returns only the current system date without the exact 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

What does the F4 key do in MS Excel after applying a format?

A. Closes the current workbook

B. Toggles between absolute and relative reference in a formula

C. Opens the Format Cells dialog

D. Repeats the last action (e.g., formatting)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F4 repeats the last command or action. In a formula editing mode, F4 cycles reference types.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, which view is best for editing the content of individual slides in detail?

A. Slide Sorter view

B. Normal view

C. Reading view

D. Outline view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Normal view allows editing slide content, notes, and thumbnails.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function returns the number of cells in a range that meet multiple criteria?

A. COUNTIFS()

B. SUMIFS()

C. DCOUNT()

D. COUNTIF()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
COUNTIFS handles multiple criteria.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs