q1- From worksheet sheet3, in cell E11, find the sum of all Total Sales for 2nd half Bonus which are more than 50 by employees aged more than 40.

q2- From worksheet sheet3, in cell J4, find the Rank based on the following conditions: 20

q3- From worksheet sheet3, in cell C11, find how many Employees having allowance more than 20 gets 1st half Bonus more than 40?

q4- From worksheet sheet3, in cell 14, display the Performance of an employee as "Outstanding" if the 1st half Bonus is more than 50 and 2nd half Bonus is more than 50. Otherwise display "Good". Replicate the formula to 15:18.

Excel Microsoft Excel he Home insert Page Layout Formula Data Review View Calibri 14 . - General -AN A Wrap Test Merge Center Pacte BIU / # Conditional Format Cell Formatting Table Styles In Die Fanat Clipboard Font Alignment Number Cell E11 A c D G 1 2 Allowance Performance Rank 3 Employee Employee Employee Name Age Abdullah 33 John 35 Riyan 41 Mohammed 26 Gopal 28 Total Sales 250 210 200 200 240 5 Bonus (1st half) 75 80 75 25 10 25 Bonus (2nd half) 65 70 60 50 45 6 7 8 60 15 S5 8 9 10 11 22 13 14 15 15 17 38 19 21 222 24