What is the difference between the TODAY() and NOW() functions? Why is this difference important?
What will be an ideal response?
The TODAY() function uses the computers system clock to insert the current date into a cell in the worksheet. The NOW() function uses the computers system clock to insert the current date and time into the worksheet. Since dates are stored in Excel as a serial number that counts the number of days since 1/1/1900, time is calculated as a fraction of that serial number. When comparing dates in Excel, it is important to consider the effect of time in any calculations.
Computer Science & Information Technology
You might also like to view...
What is the small square in the lower right corner of a cell called?
A) Formula handle B) Fill handle C) Sizing handle D) Function handle
Computer Science & Information Technology
What is the data rate for HF tags?
A) 26Kbps B) 48Kbps C) 16Kbps D) 32Kbps
Computer Science & Information Technology