Question

Excel stores numeric date and time as:
1. Text Data
2. Numbers
3. Formulas
4. Boolean

Answer 1

Correct Answer - Option 2 : Numbers

The correct answer is Numbers.

• The date serial number, also known as the date-time serial number, is a number that Excel uses to store dates and times.
• The day is represented by the integer portion of the date serial number, while the time is represented by the decimal portion.
• The date serial number 1 begins on January 1, 1900, i.e. 1/1/1900 has a date a serial number of 1.
• Microsoft incorporated this problem in Excel on purpose to keep it compatible with Lotus 1-2-3, the spreadsheet program that dominated the market at the time.
• Starting on January 1, 1900, Excel assigns a number value to each date.
• The first day of the year 1900 has a numeric value of 1, the second day of the year 1900 has a numeric value of 2, and so on. These are referred to as "date serial numbers."