Question: D Question 1 5 pts In Winners and Runnerups tab, write the formula in B20 to display the number of World Cup finals the country

D Question 1 5 pts In Winners and Runnerups tab,D Question 1 5 pts In Winners and Runnerups tab,D Question 1 5 pts In Winners and Runnerups tab,D Question 1 5 pts In Winners and Runnerups tab,
D Question 1 5 pts In Winners and Runnerups tab, write the formula in B20 to display the number of World Cup finals the country in A20 has played (that is, the number of World Cup finals in which the country was either the winner or the runnerup). Complete the formula: [ Select ] (A20,A2:C15,2, [ Select ] [ Select ] (A20,A2:C15, [ Select ] [ Select ] VD Question 2 5 pts In Host Country tab, B21 has the following formula: =IFCISNACVLOOKUP(A21, A2 : B18, 2, FALSE)) , 0, VLOOKUP(A21, A2 : B18, 2, FALSE)) The formula in B21 returns the number of times the country in A21 has hosted World Cup finals if the country has ever hosted the event; it returns 0, otherwise. Note that ISNA function checks whether the value is an N/A error, and returns TRUE if it is or FALSE otherwise. Instead of that formula, I would have had just the following formula: =VLOOKUP(A21, A2 : B18, 2, FALSE) T/F The latter formula, =VLOOKUP(A21, A2: B18, 2, FALSE)| would return an N/A error (i.e., (#N/A ) if the country in A21 has never hosted a World Cup? O True O FalseA B C D E F Country Winner Runnerup 2 Argentina 2 3 3 Brazil 5 2 A Croatia 0 5 Czechoslovakia England 7 France 2 8 Germany 9 Hungary W N N H 10 Italy 4 11 Netherlands 0 12 Spain 13 Sweden 0 14 Uruguay O 15 West Germany 16 17 18 19 Country Appeared in Finals 20 Italy 21 22 23 24 25 26 27 Breakout Group Questions Winners and Runnerups\f

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!