The Complete Excel Guide: Beginners to Advanced - How Date and Time Works

This video tutorial covers the use of date and time functions in Excel 2019. It explains the importance of setting correct date and time formats on your device and how to customize these settings in Excel. The tutorial provides practical examples of working with dates and times, including how Excel stores these as numbers and fractions of a day. It also highlights the importance of understanding formatting codes and introduces various functions for manipulating dates and times.

Why is it important to have the correct date and time settings on your device before using Excel?

• To prevent Excel from crashing

• To speed up Excel's performance

• To avoid confusion with date and time formats

• To ensure accurate calculations

What is the default short date format for English United States in Excel?

• Day-Year-Month

• Year-Month-Day

• Month-Day-Year

• Day-Month-Year

How can you change the default short date format in Excel?

• By changing the regional settings

• By editing the cell directly

• By using a formula

• By restarting Excel

Which symbol represents the day of the week in Excel's date notation?

• DDD

• Y

• M

• D

What is the significance of the cutoff year in Excel's date settings?

• It sets the first day of the week

• It changes the time format

• It decides which century is assumed for two-digit years

• It determines the default date format

What does a single 'M' represent in Excel's date notation?

• Day

• Year

• Minute

• Month

How does Excel store dates when formatted as numbers?

• As a string of text

• As a fraction of a day

• As the number of days since January 1, 1900

• As a hexadecimal value

What happens if you enter a date and time in a sentence in Excel?

• Excel will not recognize it as a date and time

• Excel will ignore the date and time

• Excel will format it as a date and time

• Excel will convert it to a number

What is the result of formatting a date as a number in Excel?

• It converts the date to a time

• It displays the date in a different language

• It shows the number of days since a base date

• It becomes a string

Which function might you use to find a date 60 days from today in Excel?

• TODAY

• EDATE

• DATEADD

• DATE