USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Date ()
|
|
|
Today ()
|
|
|
Now ()
|
|
|
Time ()
|
Detailed explanation-1: -To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).
Detailed explanation-2: -Excel current date and time formulas (static) “Ctrl +; ” – inserts the date (Windows) “Ctrl + Shift +; ” – inserts the date and time (Windows)
Detailed explanation-3: -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.
Detailed explanation-4: -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.