In cell D$27,$ use a function to determine the number of employees using the Employee ID column$\mathrm{.}2.$ In cell E$27,$ use a function to determine the number of open positions. $3.$ Use a function to combine each employees name into the format Last Name, First Name in the Employee Name column$\mathrm{.}4.$ Use a function to create a phone number with extension for each employee.Example: $555-844-3499$ #$11115.$ 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$\mathrm{.}6.$ In cell F$27$ use a function to determine the highest salary paid to an employee$\mathrm{.}7.$ In cell G$27$ use a function to determine the lowest salary paid to an employee$\mathrm{.}8.$ In cell H$27$ use a function to determine the average salary of all employees$\mathrm{.}9.$ In cell I$27$ use a function to determine the total of all salaries paid to employees$\mathrm{.}10.$ 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$\mathrm{.}11.$ 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$\mathrm{.}12.$ In cell B$35$ use a function to determine the total number of departments$\mathrm{.}13.$ In the Salary with Raise in $2024$ column, use a function to determine the new salary of each employee if