Need help with the two questions.

Question 1 (10 points) Excel Problem-Report 1 Enter the following data into a spreadsheet and then perform the following tasks: Dept Net pay Employee Number 8110 8112 81215 8127 Pay rate 10.55 11.00 95.00 10.00 Hours worked 38 40 90 40 Gross Pay Deductions 40.90 125.00 440.00 395.00 8550.00 145.00 400.00 105.00 275.90 45.00 8405.00 505.00 A B C 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 . . . b. Create a control procedure that would or at least detect, each of the errors in the data set. Question 1 (10 points) Excel Problem-Report 1 Enter the following data into a spreadsheet and then perform the following tasks: Dept Net pay Employee Number 8110 8112 81215 8127 Pay rate 10.55 11.00 95.00 10.00 Hours worked 38 40 90 40 Gross Pay Deductions 40.90 125.00 440.00 395.00 8550.00 145.00 400.00 105.00 275.90 45.00 8405.00 505.00 A B C 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 . . . b. Create a control procedure that would or at least detect, each of the errors in the data set