Excel Problem- Report 1 Enter the following data into a spreadsheet and then perform the following tasks: Employee Number 8110 8112 81215 8127 Pay rate 10.55 11.00 95.00 10.00 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. Field check Limit check Hours worked 38 40 90 40 Gross Pay Deductions 40.90 440.00 8550.00 400.00 125.00 395.00 145.00 105.00 Deductions should never exceed 40% of gross pay. There are only two departments -A and B Reasonableness test Cross-footing balance test Validity Check Net pay 275.90 45.00 8405.00 505.00 Dept Give a specific example of an error or probable error in the data set that each of the following controls would detect: A B C D b. Create a control procedure that would prevent, or at least detect, each of the errors in the data set.

Enter the following data into a spreadsheet and then perform the following tasks: 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 b. Create a control procedure that would prevent, or at least detect, each of the errors in the data set