USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=currentTime()
|
|
|
=time()
|
|
|
=now()
|
|
|
All of the above
|
Detailed explanation-1: -On a worksheet, select the cell into which you want to insert the current date or time. Do one of the following: To insert the current date, press Ctrl+; (semi-colon). To insert the current time, press Ctrl+Shift+; (semi-colon).
Detailed explanation-2: -The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
Detailed explanation-3: -Example of the NOW function in Excel As you see in the example above, the formula is simply equal to =NOW() and the date, as well as the time, are automatically displayed in the cell.
Detailed explanation-4: -When you need to show the current date and time on a worksheet, the NOW function can be used. Simply enter “=today” in the cell followed by an open and closed pair of braces “()” with no space in between to insert the current date in Excel.
Detailed explanation-5: -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).