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.

In the range B$28$:B$34,$ use a function to enter the Department Code for each company department.

Department codes are the first three letters of each department name.

Your employer would like for the department codes in range B$28$:B$34$ to be in all caps. Use a function to make each department code appear in all caps.