Which of the following function syntaxes is correct in MS Excel to extract the current system date alone, without any time stamps? MCQ with Answer and Explanation

Question
Which of the following function syntaxes is correct in MS Excel to extract the current system date alone, without any time stamps?
A. =DATEVALUE(NOW)
B. =TODAY()
C. =CURRENTDATE()
D. =NOW()
Answer: Option B
Solution (By JKSSB Mock Tests)
=TODAY() returns the current system date as a serial number date format without any time data, whereas =NOW() returns both the current 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
In MS Word, 'SmartArt' is used to:
A. Create charts
B. Add mathematical equations
C. Insert copyright-free images
D. Create visual representations like lists, processes, and hierarchies
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SmartArt provides pre-designed diagram templates.
This question belongs to: Computer Microsoft Office
Question #2
In MS Access, which SQL statement query mode is used to permanently remove specified records from an underlying data table row range?
A. Truncate Action
B. Drop Table Query
C. Delete Query
D. Remove Rows Macro
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Delete Query matches target row entries using defined criteria limits and permanently removes those records from the table database.
This question belongs to: Computer Microsoft Office
Question #3
Which of the following database tools in MS Access is explicitly used to extract selective records matching specific criteria across multiple underlying tables?
A. Report
B. Query
C. Form
D. Macro
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Queries extract, compile, and filter specific records from multiple interconnected database tables depending on targeted user constraints.
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?