USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The current date is displayed using the function:
|
|
TODAY
|
|
|
YEAR
|
|
|
HOUR
|
|
|
DATE
|
Explanation:
Detailed explanation-1: -The TODAY function takes no arguments; it is entered with empty parentheses. When you enter the TODAY function in a cell, it will display the current date. Each time the worksheet is recalculated or opened, the date will be updated. The TODAY function only inserts the date, time is not included.
Detailed explanation-2: -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-3: -In Excel, TODAY is a function that returns the current date.
There is 1 question to complete.