Question: PLEASE I NEED HELP WITH MY EXCEL ASSIGNMENT . IF YOU CAN INCLUDE ALL THE FORMULAS YOU USED TO KEY IN THE EXCELL SHEET I
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

W N Last Name First Name Gender Title Salary Location Performance Bonus Aikman Gary F Account Rep 41,800 Detroit Good Bonus is based on Gender and/or Fishe Bryan F Excellent performance. Senior Account Rep 51,300 Atlanta 1. If the employee is Female (F), and the 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 calculate the bonus. 14 Heatley Megan Senior Account Rep 51,900 Cleveland Good 15 Bobbitt Oronzo 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
