DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How do you display current date only in MS Excel?
|
|
Date ()
|
|
|
Today ()
|
|
|
Now ()
|
|
|
Time ()
|
Explanation:
Detailed explanation-1: -To insert today’s date in Excel you simply type “=today” in the cell and then open and close brackets “()” with nothing in between them.
Detailed explanation-2: -Excel current date and time formulas (static) “Ctrl +; ” – inserts the date (Windows) “Ctrl + Shift +; ” – inserts the date and time (Windows)
There is 1 question to complete.