Question: A B c D E F G H 1 2 3 4 Student Name Studenti Tutorial number leg. MT4): Tutor name (e. stan karanasios Note:

 A B c D E F G H 1 2 3
4 Student Name Studenti Tutorial number leg. MT4"): Tutor name (e. stan

A B c D E F G H 1 2 3 4 Student Name Studenti Tutorial number leg. MT4"): Tutor name (e. stan karanasios Note: the tutorial number can be found on Blackboard class Timetable &linkstat): 5 6 7 Name League Cavani Lampard Silver Bamford Suarez World Cup Total Goals 0 0 0 0 45 8 9 10 Name Competition Goals u Cavani League 120 12 Lampard League 90 13. Silver League 140 14 Bamford League 15 Suarez League 98 16 Cavani World Cup 14 17 Lampard World Cup 11 18 Silver World Cup 16 19 Bamford World Cup 20 Luis World Cup 21 0 22 4 Task 1 (Worksheet 1). 1 question (3 marks) Cells Task/problem Example Excel Funetions/features to you should use Limit yourself to functions we have covered in tutorials QI EIT:FIS List goals per competition type: Cells A11:120 contain details of soccer players and their league goals and World Cup goals. Cavani scored 120 League goals (B11) and 14 World Cup goals (B16). The current format for displaying goals is messy. Display goals in a more meaningful way in cells E11:15. Write a formula that will populate the cell with the League and World Cup goals based on the data in cells AIL:B20. Where there is an error in the data in All:B20 then display "Error in data" Therefore, E11 should display 120, and F11 should display 14, Do this with one formula that is created for Ell and copied to E11 FIS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!