DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Type Date/Time and update it time to time
|
|
|
Use Date and TIme function
|
|
|
Use Today function
|
|
|
Use Now function
|
Detailed explanation-1: -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-2: -Insert an automatically updatable today’s date and current time. If you want to input today’s date in Excel that will always remain up to date, use one of the following Excel date functions: =TODAY()-inserts the today date in a cell. =NOW()-inserts the today date and current time in a cell.
Detailed explanation-3: -The NOW function takes no arguments; it is entered with empty parentheses. When you enter the NOW function in a cell, it will display the current date and time. Each time the worksheet is recalculated or opened, the date and time will be updated.
Detailed explanation-4: -Select the cell in which you want the current date to appear. Type “=TODAY()” without the quotation marks and press Enter. The current date now appears in the cell, in the default date format.
Detailed explanation-5: -To enter the current date and time, use the NOW function. Note: the NOW function takes no arguments. This time will update automatically whenever the sheet is recalculated.