Challenger App

No.1 PSC Learning App

1M+ Downloads
Which function displays current date and time in MS Excel?

AToday()

BTime()

CNow()

DDate()

Answer:

C. Now()

Read Explanation:

NOW is an Excel DATE function that shows the current system date and time in an Excel worksheet. This function does not take any arguments and only gives the system date time on the system in which the function is being used. The method to use this function is NOW(). Displaying the current date: To display the current date in a cell, simply enter the formula =TODAY(). The cell will show the current date, and it will update automatically each time you open the workbook or recalculate the worksheet. The TIME Function is categorized under Excel DATE/TIME functions. TIME helps us to create a time with individual hour, minute, and second components. DATE(year, month, day) returns a serial number of a date based on the year, month and day values that you specify.


Related Questions:

Which chart can be created in EXCEL?
In Excel a valid cell address is like:
In Excel filter option is used to

Which of the following Excel 2007 features is used to analyse data by creating tables and charts based on it?

Which is not a data type in Excel?