K L Insert the YEARFRAC function in cell H9 to calculate difference between the first employee's hire date the date in cell L2. 12/31/2021 90,000 alary $ Change the reference of L2 in the YEARFRAC function to the mixed reference L$2 Bonus amount Raise Status Select the range G9:19. the range containing the YEAR and YEARFRAC functions and use Auto Fill to copy the functions to the range G10:H33. Select Fill Without Formatting to preserve the formatting, including borders.