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.

$2.$ 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.

$3.$ 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.

$4.$ 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.

$5.$ 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.

$6.$ 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.