Microsoft Excel 2021365 - Beginner to Advanced - Exercise 04 - ork with the date and time functions

This video tutorial guides viewers through using Excel formulas to extract date components such as month, day, year, weekday number, and names. It also demonstrates how to use the TEXT function for formatting and the IF formula to check if a date falls on a Friday. The tutorial encourages practice and provides step-by-step instructions for each task.

What is the purpose of the task described in the first section?

• To learn how to format cells in Excel

• To create a chart from date data

• To learn how to use conditional formatting

• To practice extracting date components using formulas

Which function is used to extract the month from a date in Excel?

• MONTH

• YEAR

• WEEKDAY

• DAY

How do you extract the weekday number from a date in Excel?

• Using the YEAR function

• Using the MONTH function

• Using the WEEKDAY function

• Using the DAY function

What function is used to return the weekday name in text format?

• FORMAT

• WEEKDAY

• DATE

• TEXT

How can you determine if a date is a Friday using Excel formulas?

• By using the DAY function

• By using the IF formula with the weekday number

• By using the YEAR function

• By checking if the month is December