In MS-Excel 2010, which of the following function returns the serial number of the current date and time?

Correct option is C

Correct Answer: C) NOW
Explanation:
· The NOW() function in MS-Excel is used to retrieve the current system date and time simultaneously.
· In Excel's internal system, dates and times are stored as serial numbers. The integer portion of the serial number represents the date, while the decimal (fractional) portion represents the time.
· This function is "volatile," meaning it updates automatically every time the worksheet is recalculated or reopened.
Information Booster:
· Excel’s date system starts from January 1, 1900, which is assigned the serial number 1. For example, a serial number like $45270.5$ would represent mid-day (12:00 PM) on a specific date.
· While NOW() provides both date and time, the TODAY() function returns only the serial number for the current date (with the time portion set to midnight).
Additional Knowledge:
· NOT: This is a logical function used to reverse the value of its argument. If the condition is TRUE, NOT returns FALSE; if FALSE, it returns TRUE.
· NPER: This is a financial function that calculates the total number of payment periods for an investment or a loan based on constant payments and a fixed interest rate.
· NPV: Standing for Net Present Value, this financial function calculates the net value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).