HomeTestsSearchRankProfile
easyMCQCUET Accountancy 2025 3 June Shift 22026Accountancy
1 mark

What is the difference between the TODAY() and NOW() functions in spreadsheet applications?

  1. A
    TODAY() returns current Time while NOW() returns current day.
  2. B
    TODAY() returns today's day while NOW() returns current time only.
  3. C
    TODAY() returns current month while NOW() returns current date.
  4. D
    TODAY() returns today's date while NOW() returns current date and time simultaneously.

Solution & Step-by-step Explanation

In Excel/Spreadsheets, the TODAY() formula displays only the current calendar date stamp, whereas NOW() provides both the current date along with the active system clock time.

Practice this question

Try it yourself before checking the explanation above.

What is the difference between the TODAY() and NOW() functions in spreadsheet applications?
A
TODAY() returns current Time while NOW() returns current day.
B
TODAY() returns today's day while NOW() returns current time only.
C
TODAY() returns current month while NOW() returns current date.
D
TODAY() returns today's date while NOW() returns current date and time simultaneously.

Share This Question

Computerised AccountingSpreadsheetExcel Date Functions

Related Questions

easyMCQ

Which one of the following statements is true?

easyMCQ

Which of the following statements is not correct?

easyMCQ

Which one of the following statements is correct?

easyMCQ

The product formed by the reaction of an aldehyde with a primary amine is:

easyMCQ

Which part of the tobacco plant is infected by Meloidogyne incognita?

easyMCQ

The term ecosystem was coined by:

Ready for a Full Test?

Practice with timed mock tests and track your performance across Accountancy.

Browse TestsLeaderboard

Discussion