LIVE Course for free

Rated by 1 million+ students
Get app now
JEE MAIN 2023
JEE MAIN 2023 TEST SERIES
NEET 2023 TEST SERIES
NEET 2023
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
+1 vote
313 views
in General by (30.0k points)
closed by
Which of the following functions is used to display only current system date in Ms Excel 2010?
1. Date() 
2. Today()
3. Time()
4. Now() 

1 Answer

0 votes
by (54.0k points)
selected by
 
Best answer
Correct Answer - Option 2 : Today()

The correct answer is Today().

  • The TODAY() function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened.
  • You can also use F9 to force the worksheet to recalculate and update the value.
  • If you need the current date and time, use the NOW() function. 

  • The DATE() Function in Excel is categorized under Excel Date/Time Functions.
  • It is the main function used to calculate dates in Excel.
  • TIME() function is a built-in function that allows you to create a time with individual hour, minute, and second components. 

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...