Excel Problem

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{.}00$

$35794216\mathrm{.}5050825\mathrm{.}00205\mathrm{.}00620\mathrm{.}00$

$8165435\mathrm{.}0040200\mathrm{.}0045\mathrm{.}00245\mathrm{.}00$

$96324857\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.

Can you please explain how to do this in excel