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. =TODAY()
B. =NOW()
C. =DATEVALUE(NOW)
D. =CURRENTDATE()
Answer: Option A
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 PowerPoint, which option allows you to change the background style of a slide?
A. Slide Design
B. Background Styles
C. Both A and B
D. Format Background
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In PowerPoint, you can right-click and select 'Format Background' or use the 'Background Styles' dropdown under Design tab to change the background.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, what does the '&' operator do?
A. Adds numbers
B. Performs logical AND
C. Concatenates text strings
D. Raises to power
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
& joins text.
This question belongs to: Computer Microsoft Office
Question #3
In MS Word, what shortcut key combination inserts a small superscript index character format slightly above the baseline text level?
A. Ctrl + =
B. Ctrl + Shift + +
C. Ctrl + Alt + S
D. Alt + Shift + P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + Shift + Plus Sign (+) converts selected characters into superscript formatting. Ctrl + Equal Sign (=) applies subscript formatting.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Operating Systems 510 Memory and Storage Devices 438 CPU (Central Processing Unit) 327 Computer Software 347 Computer Fundamentals 326
Explore Subjects
Science 4430 Maths 5575 History GK 3374 Computer 5279 English 15164
Practice Mix
Which soil is generally found along the foothills of the Himalayas?
The Coromandel Coast receives most of its rainfall from:
Which of these is a famous folk dance of Tripura?
The 'BCCI' stands for:
What does the term 'cache hit' refer to?