In cell D$27,$ use a function to determine the number of employees using the Employee ID column.

In cell E$27,$ use a function to determine the number of open positions.

Use a function to combine each employees name into the format Last Name, First Name in the Employee Name column.

Use a function to create a phone number with extension for each employee.

Example: $555-844-3499$#$1111$

In the Merit Raise column, use a function to determine if the individual should receive a merit raise. An employee should receive a merit raise if they have been with the company for more than four years. The output should be "Yes" if they are to receive a merit raise, otherwise should be $"$No$".$

In cell F$27$ use a function to determine the highest salary paid to an employee.

In cell G$27$ use a function to determine the lowest salary paid to an employee.

In cell $H27$ use a function to determine the average salary of all employees.

In cell I$27$ use a function to determine the total of all salaries paid to employees.