What does the "NOW" function return? 

The correct answer is Both current date and time.

Key Points

• The "NOW" function is used to retrieve both the current date and time.
• The value returned by "NOW" updates automatically whenever the spreadsheet is recalculated.
• The format of the value depends on the cell's formatting settings (e.g., date, time, or both).
• The "NOW" function is dynamic, meaning the value changes every time the sheet is refreshed or recalculated.

Important Points

• The "NOW" function is available in most spreadsheet software such as Microsoft Excel, Google Sheets, and others.
• It is commonly used for dynamic timestamping or for calculations requiring the current date and time.
• "NOW" differs from the "TODAY" function, which only returns the current date without the time.