DATABASE FUNDAMENTALS
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: -DateValue function converts a date string (for example, “10/01/2014") to a date/time value. TimeValue function converts a time string (for example, “12:15 PM") to a date/time value.