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 numberof goals scored. Excel will then update the calculations automatically. After afew more games, the number of goals has changed. Change the number

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

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 Databases Questions!