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 ColumnThere 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

Employee Number	Pay rate	Hours worked	Gross Pay	Deductions	Net pay	Dept
8110	10	38	380	250.00	275.90	A
8112	35	40	1200	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

can you do the data validation rule in excel for each step? or show me how to enter it