Question

04 Create a table as shown and calculate abonus for each player based on the following criteria byusing the appropriate formula: If a player Goals scored meets or exceeds his goals targets he receives abanus equal to £ 1000 for each goal he has scored else he receives an encouraging message. Edit the first row having the current data, change the default data Style. Target Scores Name Rooney Drogba Ranalda Owen Goal Target 20 15 Goal Scored 15 18 16 Bonus 15,000 NO chance Sunshine 16,000 21,000 e​

Answer 1

Explanation:

Create a table as shown and calculate abonus for each player based on the following criteria byusing the appropriate formula: If a player Goals scored meets or exceeds his goals targets he receives abanus equal to £ 1000 for each goal he has scored else he receives an encouraging message. Edit the first row having the current data, change the default data Style. Target Scores Name Rooney Drogba Ranalda Owen Goal Target 20 15 Goal Scored 15 18 16 Bonus 15,000 NO chance Sunshine 16,000 21,000 e