Case Problem $1,$ Payroll

You recently accepted a part time job with NuBiz Financial Services to earn extra income.

Nukiz specializes in providing business services to small and growing companies in the

Upper Cumberland and surrounding areas. Your supervisor has asked you to convert

MGorp's, payroll from paper to electronic form. You decide to use Excel, since you have

developed valuable spreadsheet skills.

Here is the employee payroll data.

Itemize Gross Pay, Retirement, Taxes, Health, and Net pay for each employee. Deduction

data is as follows: retirement rate is $5\%,$ tax rate is $8\%,$ and health insurance is fixed at $$20$

a month. Also, run some statistics to show the minimum, average, and maximum of the

paychecks for the month.

You must use the following: the concept of using variables; sum, minimum, average, and

maximum functions; absolute cell addressing; merge and center, fill colors; borders for

totals; and proper cell formating. Add this comment for the average pay value: Average pay

for January. Rename the worksheet to Jan Payroll.