Sample excel test for job interview

I built this for a class I was teaching because a number of students told me they were being given Excel tests as part of the job interview process.

Download the Excel file from: bit.ly/3ilrnq4

I was inspired by this video by Ann Emery:    • A Real-Life Excel Test from a Job Intervie...  


If you want more practice, see also:
How to ACE Excel Interview Questions by Leila Gharani:    • How to ACE Excel Interview Questions (Base...  
Excel Test for Job Interview 2022 by Data 360 YP:    • Excel Dashboard Design - How to build inte...  


Timestamps:
0:00 Getting started
2:46 Remove duplicates (for full-time, part-time, contractor, etc)
3:49 Toggling between absolute and relative references
4:40 Extract area code from phone number / last 4-digits from work phone
5:45 Using dates (extracting birth year and calculating age)
11:10 Counting companies between 500-1,000 employees
13:06 Creating a table with company size categories (500-1000, more than 1000, etc)
20:30 How many were born in June?
22:12 Sort by month hired (so goes from January to December)