Need help answering these two problems.

Question 2 (12 points) Excel Problem Report 2 Create the following validation rule in a spread sheet before entering the numbers the spreadsheet There should be at least six rows . . . First colunm-Employee numbers are four digit in length Second column-Maximum pay rate is 50 and the minimum is 20 Third Column-Hours worked cannot exceed 75 Fourth column Gross rate is payrate multiplied by hours Fifth column-Deduction cannot exceed 35% of gross pay Sixth Colum-Net pay is Gross pay less deduction Seventh Column There are two departments A and B State the type of control applied to each colunm If you found an error in the spread sheet, please document and correct the right amount . . Dept Employee Number Hours worked Pay rate Gross Payal Deductions Net pay 8110 8112 81215 8127 10 35 95.00 10.00 38 40 90 40 380 1200 8550.00 400.00 250.00 395.00 145.00 105.00 275.90 45.00 8405.00 505.00 A B C D Question 3 ( 3 points) Explain the types of control implemented report 1 and 2 ( preventive, detective or corrective). Compare the controls in Report 1 and Report 2. which would you recommend and why? Question 2 (12 points) Excel Problem Report 2 Create the following validation rule in a spread sheet before entering the numbers the spreadsheet There should be at least six rows . . . First colunm-Employee numbers are four digit in length Second column-Maximum pay rate is 50 and the minimum is 20 Third Column-Hours worked cannot exceed 75 Fourth column Gross rate is payrate multiplied by hours Fifth column-Deduction cannot exceed 35% of gross pay Sixth Colum-Net pay is Gross pay less deduction Seventh Column There are two departments A and B State the type of control applied to each colunm If you found an error in the spread sheet, please document and correct the right amount . . Dept Employee Number Hours worked Pay rate Gross Payal Deductions Net pay 8110 8112 81215 8127 10 35 95.00 10.00 38 40 90 40 380 1200 8550.00 400.00 250.00 395.00 145.00 105.00 275.90 45.00 8405.00 505.00 A B C D Question 3 ( 3 points) Explain the types of control implemented report 1 and 2 ( preventive, detective or corrective). Compare the controls in Report 1 and Report 2. which would you recommend and why