Breakout Group (BG) 3
This is a preview of the published version of the quiz
Started: Oct 26 at 11:14a.m.
Quiz Instructions
Please submit your answers by the end of the class. Every student should submit their own answers.
The data on World Cup finals associated with this BR Exercise can be found
here
(https://canvas.ubc.ca/courses/123136/files/29147327?
wrap=1)
(https://canvas.ubc.ca/courses/123136/files/29147327/download?download_frd=1)
.
3.34 pts
Question 1
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:B15,
[ Select ]
,FALSE)+
[ Select ]
(A20,A2:C15,
[ Select ]
,FALSE)
3.33 pts
Question 2
In the formula in Q1, suppose one changes the values of last arguments in those two functions from FALSE to TRUE.
Assume that the other blanks were filled correctly. The new formula would be as follows:
=
________(A20,A2:B15,
________,
TRUE
)+
________(A20,A2:C15,
________,
TRUE
)
T/F The new formula (when the other blanks are properly filled) would work in the same way as the correct formula in Q1
for any country name you can enter in A20 regardless of whether the country has played a World Cup final or not.
True
False
3.33 pts
Question 3
In Host Country tab, B21 has the following formula:
=IF(ISNA(VLOOKUP(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.