Microsoft Excel 2021365 - Beginner to Advanced - Applying Date and Time Formats

This video tutorial covers the basics of number formatting in Excel, focusing on date and time formatting. It explains how dates are stored as numbers in Excel, starting from January 1, 1900, and how to apply short and long date formats. The tutorial also discusses the importance of locale settings for date formats, especially when working with international clients. Additionally, it covers time formatting options, including 24-hour and 12-hour clocks, and how to apply formatting to empty cells.

What does Excel consider as day #1 in its date system?

• 1st January 2000

• 1st January 1900

• 31st December 1899

• 1st January 1970

How can you quickly apply a short date format to a column in Excel?

• Use the Format Painter tool

• Type the date manually in each cell

• Select the column and choose Short Date from the dropdown

• Right-click and select Format Cells

Which keyboard shortcut can be used to select cells for formatting in Excel?

• Ctrl + V

• Ctrl + C

• Ctrl + A

• Ctrl + Shift + Down

Why is it important to adjust the locale settings in Excel?

• To change the font style

• To increase the speed of calculations

• To enable macros

• To ensure date formats match regional preferences

What is the default time format in Excel?

• 12-hour clock with AM/PM

• 24-hour clock showing hours and minutes

• 12-hour clock showing only hours

• 24-hour clock showing hours, minutes, and seconds

How can you customize the display of time in Excel?

• By selecting a custom format from the number format options

• By adjusting the cell width

• By changing the font size

• By using the Format Painter

What happens if you apply date formatting to an empty column in Excel?

• It will format any future entries as dates

• It will automatically fill with today's date

• It will display an error message

• It will remain unchanged