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

The video tutorial guides viewers through practicing date and time formulas in Excel. It covers extracting components like month, day, year, weekday number, and names from a date. The tutorial also demonstrates using the TEXT function for formatting and an IF formula to check if a day is Friday. Viewers are encouraged to pause and try the exercises before seeing the solutions.

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

• To create a chart from date data

• To practice extracting date components and checking for Fridays

• To learn how to format cells in Excel

• To learn how to use pivot tables

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

• WEEKDAY

• YEAR

• DAY

• MONTH

How does the WEEKDAY function help in determining the day of the week?

• It converts the date into a string

• It calculates the number of days in a month

• It provides a number representing the day of the week

• It formats the date into a long date format

Which function is used to return the weekday name in a short format?

• TEXT

• DATE

• CONVERT

• FORMAT

What does the IF formula check for in the final task?

• If the month is December

• If the day is a Friday

• If the date is a holiday

• If the year is a leap year