USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Date
|
|
|
Number
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -There are times when we want to extract time from a date and time. To do this, you will need to use a formula that is based on the MOD function. This article provides an elaborative procedure on how you can use the MOD function to extract time from a date and time in excel.
Detailed explanation-2: -Excel current date and time example NOTE: Excel uses a 24-hour clock when it outputs the time. As you can see, the =TODAY() formula only includes the day, month and year. The =NOW() function displays more information, showing the day, month, year, hour and minutes (using a 24-hour clock).
Detailed explanation-3: -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-4: -The correct answer is Today(). The TODAY() function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened. You can also use F9 to force the worksheet to recalculate and update the value. If you need the current date and time, use the NOW() function.