Microsoft Excel 2021365 - Beginner to Advanced - Calculate Dates with EDATE and EOMONTH

The video tutorial explains how to use the EO Month and E Date functions in Excel. EO Month is used to find the last day of a month, which is useful for calculating loan payment dates. The tutorial demonstrates how to fill a series of numbers in Excel efficiently and how to use EO Month to list the last day of each month. It also covers the E Date function, which calculates a date a specified number of months before or after a given date, and shows how to format cells to display dates correctly.

What does the EO Month function primarily calculate?

• The start of the year

• The end of the month

• The first day of the month

• The middle of the month

How many payments are made over the course of a 30-year loan?

• 360 payments

• 480 payments

• 240 payments

• 120 payments

What is a quick method to fill a series of numbers in a spreadsheet?

• Typing each number manually

• Using the fill handle with a right-click drag

• Copying and pasting each number

• Using a calculator

What does the EO Month function return when the month parameter is set to 0?

• The first day of the next month

• The last day of the current month

• The last day of the previous month

• The first day of the current month

How does Excel handle leap years when using the EO Month function?

• It ignores leap years

• It adds an extra day to February

• It subtracts a day from February

• It does not affect February

What is the purpose of the E Date function?

• To calculate the end of the year

• To calculate the number of days in a month

• To determine the start of the month

• To find a date a specific number of months before or after a given date

How can you use the E Date function to find a date two months ahead?

• Set the month parameter to 1

• Set the month parameter to 0

• Set the month parameter to 2

• Set the month parameter to -2