Using the data on the spreadsheet, please answer the questions. Show your work in Excel. 1. Use Vlookup on the Dept ID on HC_Data sheet, to populate any one column with Department Names that are provided in Description Sheet. (1 Point) 2. Using appropriate Excel functions, calculate the years of service in one column and age in another column on the HC_Data sheet with 2017 as the base year. (1 Point) 3. On the HC_Data sheet, in a separate column, use the concept of Nested IF in Excel, to determine who is eligible to retire end of December 2017. Anybody who meets any one of the criteria below is eligible to retire. Note that IF function must be performed in one column (and not multiple columns) (2 points) Criteria 1: Anyone at least 68 years of age Criteria 2: Anyone at least 62 years of age and has at least 22 years of service Criteria 3: Anyone at least 55 years of age and has at least 25 years of service 4. Based on the retirement eligibility determined from the questions above, in a separate column indicate which retirement criteria the employee met. For instance, if employee met Criteria 1, indicate Met Criteria I in a separate column. If an employee met both Criteria 1 and 2, then indicate Met Criteria 1&2 and so on. Results of which criteria(s) were met should be indicated in one column. (1 Point) 5. Insert multiple Pivot Tables on PIVOT sheet to show: a. Workforce Composition by Gender & Category. Create a Pivot Chart of your choice to depict this info with meaningful titles, legends, etc. (2 Points) b. Workforce Composition by Gender and Education. (1 Point) c. Benefits Eligibility (Eligible vs. Not Eligible) by Job Status (1 Point) 6. Analyze Benefits Eligibility, Healthcare Enrollment and Healthcare Utilization by Age and Gender using Excel Functions, Pivot Tables and Charts. Summarize your findings. - 5 Points Upload the completed file. Make sure to rename the file by replacing FirstName and LastName wit h your actual FirstName and LastName