Group the data according to age such that:
a. ages 0-19 will be grouped as Minor
b. 20-40 will be grouped as Young Adults
c. 41-60 Will be grouped as Old Adults
d. Above 60 will be grouped as elderly
2 Find Minimum and Maximum Hire Date
3 Count number of employees where Gender is Male (D)
4
Use Vlookup to insert Ethnicity into the dataset (e.g Grouping them into A, B, C, e.t.c) from
Ethnicity sheet using Ethnic Group as a unique reference.