In Excel, which function returns the serial number of a specific date given year, month, day? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the serial number of a specific date given year, month, day?

A. TODAY()

B. NOW()

C. DATE()

D. DATEVALUE()

Answer: Option C

Solution (By JKSSB Mock Tests)

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 Word, to save a document with a new name, press:

A. Shift + F12

B. Ctrl + S

C. F12

D. Ctrl + Shift + S

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F12 is Save As.

This question belongs to: Computer Microsoft Office

Question #2

In Access, which of the following is a valid way to import data from an Excel spreadsheet?

A. File > Open > Excel

B. Create > Import Excel

C. Home > Import

D. External Data tab > Excel

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The External Data tab has options to import from Excel. File > Open opens Access databases, not import.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, what is a form used for?

A. Executing SQL commands

B. Storing raw data

C. Summarizing data for printing

D. User-friendly interface for data entry and viewing records

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Forms provide a graphical interface for data input and display. Reports are for printing summaries, tables store data.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs