need help on the spread sheet and the right option to choose

In Column G (Bonus), enter a formula that will calculate the amount of each employee's bonus. The bonus is calculated as follows: IF the Employee's probation has passed, then check to see IF the Employee's Performance score is above the average of all Performance scores. If so, then the bonus is the Employee's Years Worked the Bonus Multiplier, otherwise the employee gets no bonus ($0). Don't use the Performance target in this case. Once done, use the Scenario tool to select the Dataset 1 scenario. What is Bob's bonus? A) $247.50 B) $299.92 OC) $252.78 OD) $270.85 Calibri 10 In Copy fsmat Painter AA === 3. Marge a center Insert Delete Format $ % 9 8-98 Cles Conditional format all Formatting Table - Syles- Styles hitton Select Clipboard For Alignment Number Cells E17 B D E F G H 5 2 3 4 5 6 Targets Probation (in years) Performance General Opinion 6 G Bonus Do not edit this cell! "BonusMulti" 8 9 10 Employee General Opinion (G or B) Probation Years Remaining Bonus Bob Carol Ted Alice Years Worked 5 3 7 Performance (0 to 10) 6 7 4 G G B B 4 6 4- 11 12 13 14 15 16 17 18 19 20 21 What if Vlookup IF Multiple Worksheets North South East West Bonus Question Ready Type here to search In Column G (Bonus), enter a formula that will calculate the amount of each employee's bonus. The bonus is calculated as follows: IF the Employee's probation has passed, then check to see IF the Employee's Performance score is above the average of all Performance scores. If so, then the bonus is the Employee's Years Worked the Bonus Multiplier, otherwise the employee gets no bonus ($0). Don't use the Performance target in this case. Once done, use the Scenario tool to select the Dataset 1 scenario. What is Bob's bonus? A) $247.50 B) $299.92 OC) $252.78 OD) $270.85 Calibri 10 In Copy fsmat Painter AA === 3. Marge a center Insert Delete Format $ % 9 8-98 Cles Conditional format all Formatting Table - Syles- Styles hitton Select Clipboard For Alignment Number Cells E17 B D E F G H 5 2 3 4 5 6 Targets Probation (in years) Performance General Opinion 6 G Bonus Do not edit this cell! "BonusMulti" 8 9 10 Employee General Opinion (G or B) Probation Years Remaining Bonus Bob Carol Ted Alice Years Worked 5 3 7 Performance (0 to 10) 6 7 4 G G B B 4 6 4- 11 12 13 14 15 16 17 18 19 20 21 What if Vlookup IF Multiple Worksheets North South East West Bonus Question Ready Type here to search