Ungroup the worksheets and ensure the employee_info worksheet is active. click cell g6 and enter a nested logical function that calculates employee 401k eligibility. if the employee is full time (ft) and was hired before the 401k cutoff date 1/1/19, then he or she is eligible and y should be displayed, non-eligible employees should be indicated with a n. be sure to utilize the date located in cell h3 as a reference in the formula. use the fill handle to copy the function down completing the range g6:g25