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

Question
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 PowerPoint, which option is used to group objects together so they can be moved or resized as one?
A. Group
B. Combine
C. Ungroup
D. Merge
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Grouping objects allows them to be treated as a single object. Ungroup separates them.
This question belongs to: Computer Microsoft Office
Question #2
In MS Access, to see the SQL code behind a query, switch to:
A. Design View
B. Layout View
C. SQL View
D. Datasheet View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
SQL View displays the SQL statement.
This question belongs to: Computer Microsoft Office
Question #3
What is the function of the keyboard shortcut Ctrl + J when working inside an active document in MS Word?
A. Inserts a clear hyperlink text reference field
B. Justifies the text alignment flush with both margins
C. Indents the paragraph from the left page margin
D. Applies center alignment formatting to the paragraph
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + J applies Justify alignment, distributing spacing between words so that text aligns flush with both the left and right page margins.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Cyber Security 269 Computer Abbreviations 369 Operating Systems 510 Computer Software 347 CPU (Central Processing Unit) 327
Explore Subjects
Accountancy and Statistics 3179 Science 4430 Computer 5279 History GK 3374 Current Affairs 575
Practice Mix
The receipt ______ they gave is fake.
Identify the error: 'He is the most young of the team.'
Which view in PowerPoint displays thumbnails of all slides for easy rearrangement?
A sum of money at compound interest doubles in 5 years. In how many years will it become 4 times?
Which of the following is an example of educational software?