Which of the following functions is used to insert the current date and time in MS Excel 2010?

Correct answer: NOW(). NOW() returns the current date and time.

• DATE(): DATE() builds a date from year, month, and day values.
• TIME(): TIME() builds a time from hour, minute, and second values.
• TODAY(): TODAY() returns only the current date.