done in excel showing formulas used

(a) Using the VLOOKUP function and the table located in cells 14:18, enter an appropriate formula in cell G3 to determine which overtime rate "Rebecca French" will receive based on her overtime hours. Using the autofill feature, determine which overtime rate all the other cashiers will receive. (b) Enter an appropriate function in cell J10 to find the total number of cashiers who worked more than 7 overtime hours. (c) Enter an appropriate formula in cell 111 to determine the total number of cashiers from Couva. (d) Enter an appropriate formula in cell J12 to find out the total number of cashiers from Arima who earned more than $2000 in overtime pay. (e) By entering different (but appropriate) formulas in cells 113, 114 and 115, determine the most overtime hours worked, third least overtime hours worked and the fourth most overtime hours worked. (1) Using an appropriate formula in cell J16, find the number of male cashiers. (e) Enter an appropriate formula in cell 117 to find the total number of female cashiers who earned less than $1000 in overtime pay. (h) Enter an appropriate formula in cell 118 to find the total number of overtime hours worked. (1) Sort the cashiers in order of Overtime Hours Worked in ascending order. NO 2 3 Overtime Rate Overtime Hours Worked 3 Payment 4 5 6 7 Cashier 1 Rebecca French 2 Aleena Macintyre 3 Clay Rozenda 4 Carlos Soltero 5 Carl Jackson 6 Monica Federle z Dorothy Badders 8 Lisa Green 9 Carlos Daly Sex Female Female Male Male Male Female Female Female Male Address San Fernando Couva Debe Couva Port of Spain Chaguanas Sangre Grande Couva Arima 1 5 11 14 8 9 8 9 10 5.5 11.5 11 12 13 14 3 10 7 11.5 15 16 17 18 10 Claudia Miner 11 Don Miller 12 Annie Cyprus 13 Grant Carroll 14 Don Miller 15 Neola Schneider 16 Allen Rosenblatt 17 Sylvia Foulston 18 im Radford 19 Alan Barnes 20 Jack Garza Female Male Female Male Male Female Male Female Male Male Female Couva Siparia Chaguanas Mayaro Arima Couva St Augustine Marabella Couva Maracas 4 13 9 8 2.5 19 20 21 22 6 8 VLOOK UP TABLE Min Value of Range 0 4 Overtime Range Overtime Rate Per Hour 0-3 50 4-6 100 7-10 150 11-15 200 7 11 Number of cashiers who worked more than 7 overtime hours Number of cashiers from Couva Number of cashiers from Arima who earned more than $2000 in payment Most overtime hours worked Third least overtime hours worked Fourth most overtime hours worked Number of male cashiers Number of female cashiers who earned less than $1000 Total number of overtime hours worked