$9\mathrm{.}1\mathrm{.}8$

Applied Lab: Perform Logical Operations on Payroll Data

As a payroll specialist, you are performing analysis on payroll amounts for compensation, expenses, and benefits to ensure that they are aligned with corporate policies and records. You need to create formulas to help you analyze the information. Perform the following actions:

On the Bonus sheet, select cell D$2,$ and create an IF or IFS formula to determine the employee's bonus based on their performance review rating.

On the Formulas sheet, in cell D$3,$ enter a formula to return the sum of the overtime paid for employees in the IT department. Use the defined names for the array ranges.

On the Formulas sheet, in cell D$6,$ enter a formula to find the average benefit cost for the Legal department. Use the defined names for the array ranges.

On the Formulas sheet, in cell D$9,$ enter a formula to find the total pay for employees in the Finance department who are part$-$time employees $($PTE$).$ Use the defined names for the array ranges.

On the Formulas sheet, in cell D$12,$ enter a formula to find the average pay of part$-$time employees $($PTE$)$ with the Info Tech Spec I job title. Use the defined names for the array ranges.

On the Formulas sheet, in cell D$15,$ enter a formula using names and cell references for values to calculate the total expenses for the values on the left.