Enter the following data into a spreadsheet, and then perform the following tasks:

Employee Number Pay Rate Hours Worked Gross Pay Deductions Net Pay $46892115\mathrm{.}0028420\mathrm{.}00325\mathrm{.}0095\mathrm{.}0035794216\mathrm{.}5050825\mathrm{.}00205\mathrm{.}00620\mathrm{.}008165435\mathrm{.}0040200\mathrm{.}0045\mathrm{.}00245\mathrm{.}0096324857\mathrm{.}60402304\mathrm{.}0010\mathrm{.}002294\mathrm{.}00$

Required

a$.$ Calculate examples of these batch totals:

hash total

financial total

record count

b$.$ Assume the following rules govern normal data:

Employee numbers are five digits in length and range from $10000$ through $99999.$

Maximum pay rate is $$35,$ and minimum is $$15.$

Hours worked should never exceed $40.$

Deductions should be between $10\%$ and $35\%$ of gross pay.

Give a specific example of an error or probable error in the data set that each of the following controls would detect:

field check

limit check

range check

reasonableness test

cross$-$footing balance test

c$.$ Create a control procedure that would prevent, or at least detect, each of the errors in the data set.

If you can do it in excel that would be very helpful thank you!