FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The ____ function returns the current date and time based on the computer’s date and time settings.
A
Now()
B
When()
C
Current()
D
Date()
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: -The NOW function in Excel returns the current date and time value.

Detailed explanation-3: -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-4: -The time() function returns the time as text in this format: HH:MM:SS. The datetime() function returns the date and time as text in their same formats: YYYY-MM-DD HH:MM:SS.

Detailed explanation-5: -The NOW Function[1] in Excel is a formula that displays the current date and time. It is automatically refreshed anytime the workbook is opened or a change is made.

There is 1 question to complete.
Previous
Next