Step

Instructions

$1$

Start Excel. Download and open the file named Exp$19\_$Excel$\_$Ch$07\_$HOEAssessment$\_$Employees.xlsx$.$ Grader has automatically added your last name to the beginning of the filename.

$2$ The $1-$Data worksheet contains employee data. You will insert several functions to complete this worksheet. Column C contains the actual hire dates for the employees. You want to extract only the year in column $G.$

In cell G$9,$ insert the appropriate date function to extract the year from the date in cell C$9.$ Copy the function from cell $G9$ to the range G$10$:G$33.$

$3$ Next, you want to determine how many years each employee has worked for the company.