PLEASE I NEED HELP WITH MY EXCEL ASSIGNMENT . IF YOU CAN INCLUDE ALL THE FORMULAS YOU USED TO KEY IN THE EXCELL SHEET I WILL REALLY APPRECIATE. THANKS

B D E F G H K M N O P 3 Last Name First Name Gender Title Salary Location Performance Bonus Bonus is based on Gender and/or Aikman Gary F Account Rep 41,800 Detroit Good F 51,300 Atlanta Excellent performance. Fishe Bryan Senior Account Rep 1. If the employee is Female (F), and the 6 Felser Cynthia F Account Rep 40,900 Boston Average performance is Excellent the bonus is 5% of Parsley Gwen M Manager 74,200 Atlanta Excellent Salary. 8 Leslie Jean F Account Rep 48,500 Cleveland Excellent 2. If the performance is Excellent (and 9 Imber Cynthia M Senior Account Rep 48,500 Cleveland Good obviously not female) the bonus is 3%. 10 Granger Kevin M Trainee 20,500 Detroit Good 3. If the performance is Good, 1% bonus, 11 Dunes Annette F Senior Account Rep 42,600 Cleveland Good anything else is 0. 12 Cusak Barbara F Account Rep 32,800 Cleveland Average 13 Noble Linda M Account Rep 46,900 Boston Good You are required to use a logic statement to 14 Heatley Megan F Senior Account Rep 51,900 Cleveland Good calculate the bonus. 15 Bobbitt Oronzo F Account Rep 40,700 Cleveland Good 16 Lobree Cindy F Account Rep 25,800 Cleveland Average 17 Sampieri Maylou M Account Rep 38,400 Cleveland Average 8 Crowder Harold F Trainee 19,600 Phoenix Excellent 19 Beamer Laura M Trainee 21,700 Boston Average20 Powell Kathy F Account Rep 44,900 Chicago Average 21 Mills Wendy F Manager 70,900 Detroit Good Good 22 Cole Kordell M Account Rep 30,300 Miami 23 Foerster Shelly F Account Rep 44,700 Kansas City Excellent 24 Cole Crystal M Trainee 18,200 Cleveland Good 25 Guilford Betty F Account Rep 29,400 Cleveland Excellent 26 Drubin Hank F Account Rep 39,600 New York Good 27 Wood Emit Senior Account Rep 59,100 Detroit Average 28 Spinale Lorna M Account Rep 32,400 Kansas City Average 29 Bryan Ashley E Manager 76,300 Cleveland Good 30 Posten Julianne M Trainee 21,300 San Francisco Poor Good 31 Watson Fran F Account Rep 32,800 Chicago 32 Pennekamp Lynn Account Rep 33,700 New York Average 33 Fegin Nancy M Account Rep 25,200 Boston Excellent 34 Everett Holly F Senior Account Rep 61,500 Atlanta Good 35 Erpf Meredith F Account Rep 36,900 Boston Excellent 36 White Jack F Account Rep 47,800 Miami Average