USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=Now()
|
|
|
=Date()
|
|
|
=Today()
|
|
|
=Day()
|
Detailed explanation-1: -To enter a date that will update to the current date each time you reopen a worksheet or recalculate a formula, type =TODAY() in an empty cell, and then press ENTER.
Detailed explanation-2: -The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals.
Detailed explanation-3: -The TODAY Function[1] is categorized under Excel Date and Time functions. It will calculate and give the current date. It is updated continuously whenever a worksheet is changed or opened by a user. The function’s purpose is to get today’s date.
Detailed explanation-4: -TODAY() and NOW() are the predefined functions of Excel where TODAY() returns only current date whereas NOW() returns the current date and time of your system. Both functions can be used in various ways to get the date and time of the system.