
TASK – BEST BIRTHDAY EVER
What could be better than Excel Esports on your birthday? In this case, you will answer a number of questions around birthdays and see how many lucky people had their birthdays on an Excel Esports event day this year. In the data below, you are given names with dates of birth. Determine when their birthday is in 2024 and answer the questions on the “Birthday Case Answers” tab. For the later questions, you will need to use the information found on the “Calendar” tab that details Excel Esports events in 2024. Note that weekend days are Sunday and Saturday (WEEKDAY() results of 1 and 7) when no [return type] is specified (i.e., the default option).
WALKTHROUGH VIDEO PROVIDED BY ERIC KELLEY
Step by step walkthrough to solve the case.
WALKTHROUGH VIDEO PROVIDED BY JULIAN POELTL
In this video, he does a run through of the Birthday Case (data case). Video is divided in parts so you can easily skip to the part that you are stuck on to find out best solution.
MEWC
TAC
EEO