LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
488 views
in Computer by (53.1k points)
closed by
Which of the following functions returns the current date and time in MS-Excel? 
1. NOW
2. DATEVALUE 
3. TIME
4. DATE

1 Answer

0 votes
by (54.5k points)
selected by
 
Best answer
Correct Answer - Option 1 : NOW

The correct answer is NOW.

  • If a current date and time are required, the NOW function is used.

  • The TODAY function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened.
  • One can also use F9 to force the worksheet to recalculate and update the value.
  • In the Excel sheet, the Date and Time entry is very easy and can be updated as under.
  • Select the cell where the date and time are to be inserted.
  • For Date, Select Ctrl+; and press enter.
  • For Time select Shift+Ctrl+; and press enter.

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

...