FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -On the Formulas tab, in the Function Library, select NOW from the Date & Time drop-down list and then click OK.

Detailed explanation-2: -Sometimes when we want to display the current date and time in a worksheet, we can use the NOW function. The date and time will update whenever the worksheet is recalculated or opened. To do that, we need to just insert the formula =NOW() in the cell where the current date and time should appear.

Detailed explanation-3: -Detailed Solution. The correct answer is Today(). The TODAY() function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened.

Detailed explanation-4: -The NOW function in Excel enters a valid serial number of the current date and time as per Excel’s date and time system. When we insert the NOW function in a cell, it will convert the format of the cell into a custom format (m/d/yyyy h:mm).

Detailed explanation-5: -Description. Returns the serial number of the current date. The serial number is the date-time code used by Excel for date and time calculations. If the cell format was General before the function was entered, Excel changes the cell format to Date.