Microsoft Excel 2021365 - Beginner to Advanced - Understanding How Dates are Stored in Excel

This video tutorial explains how Excel handles dates and times. It begins with an introduction to the theory behind dates and times in Excel, emphasizing that they are stored as plain numbers. The tutorial then demonstrates how to apply date formatting to numbers, explaining Excel's date system, which starts from January 1, 1900. It also covers time formatting, showing how times are stored as fractions of a day. The video concludes by summarizing how to make dates and times appear correctly by applying the appropriate formatting.

What is the underlying representation of dates in Excel?

• Hexadecimal values

• Binary code

• Plain numbers

• Text strings

How does Excel determine the number for a specific date?

• By counting from the 1st of January 2000

• By using the current year as a reference

• By counting days from the 1st of January 1900

• By using a random starting point

Which format can be applied to display dates in a more readable form?

• Short Date

• Currency

• Scientific

• Percentage

How are times stored in Excel?

• As fractions of a day

• As hexadecimal values

• As text strings

• As whole numbers

What does a time value of 0.5 represent in Excel?

• 12:00 PM

• 6:00 AM

• 12:00 AM

• 6:00 PM