Question: Question 6 Every week, you are going to update the number of goals scored. Excel will then update the calculations automatically. After a few more



Question 6 Every week, you are going to update the number of goals scored. Excel will then update the calculations automatically. After a few more games, the number of goals has changed. Change the number of goals scored by each team on your table, as follows: Arsenal Chelsea Everton Ipswich Liverpool Manchester City Manchester United Tottenham West Ham 40 52 35 20 43 58 11 29 20 2. Add a function to display the number of teams who have scored more than 30 goals. 3. Change the COUNTIF function in cell F9 so that it displays the number of teams to have scored "20 or more" goals. Hint: you need to change the Criteria used in the function. The following list of acceptable criteria will be useful: More than 20 More or equal to 20 Less than 20 Less than or equal to 20 >20 >=20
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
