DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following Excel functions returns both the current date and time in a cell?
|
|
TODAY
|
|
|
NOW
|
|
|
WORKDAY
|
|
|
WEEKDAY
|
Explanation:
Detailed explanation-1: -The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
Detailed explanation-2: -What is the NOW Function? The NOW Function[1] is categorized under Excel DATE/TIME functions. The function returns the current date and time.
Detailed explanation-3: -The datetime() function returns the date and time as text in their same formats: YYYY-MM-DD HH:MM:SS.
There is 1 question to complete.