Enter the following data into a spreadsheet and then perform the following tasks: Employee Hours Dept Number Pay rate worked Gross Pay Deductions Net pay 8110 10.55 38 40.90 125.00 275.90 A 8112 11.00 40 440.00 395.00 45.00 B 81215 95.00 90 8550.00 145.00 8405.00 C 8127 10.00 40 400.00 105.00 505.00 D a. Assume the following rules govern normal data: Employee numbers are four-digits in length . Maximum pay rate is $25, and minimum is $9. . Hours worked should never exceed 45. . Deductions should never exceed 40% of gross pay. There are only two departments -A and B 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 . Reasonableness test . . Cross-footing balance test Validity Check