Correct Answer:
A. NOW()
The Excel function that returns the current date and time is NOW(). This function is volatile, meaning it updates automatically whenever the worksheet is recalculated, providing real-time information.
- DATE() is used to construct a date from individual year, month, and day components, not to return the current time.
- TODAY() returns only the current date, without the time component.
- CURRENTDATE() is not a valid Excel function.