DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=Date()
|
|
|
=time()
|
|
|
=now()
|
|
|
=Today()
|
Detailed explanation-1: -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.
Detailed explanation-2: -To insert the current date, press Ctrl+; (semi-colon). To insert the current time, press Ctrl+Shift+; (semi-colon). To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).
Detailed explanation-3: -Excel current date and time formulas (static) Static formulas are: “Ctrl +; ” – inserts the date (Windows) “Ctrl + Shift +; ” – inserts the date and time (Windows)