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