Quiz_ Breakout Group (BG) 6-2

.pdf

School

Acsenda School of Management *

*We aren’t endorsed by this school

Course

205

Subject

Mathematics

Date

Jan 9, 2024

Type

pdf

Pages

2

Uploaded by ProfPelicanMaster143

Report
Breakout Group (BG) 6 This is a preview of the published version of the quiz Started: Oct 26 at 11:18a.m. Quiz Instructions Please submit your answers by the end of the class. Every student should submit their own answers. Please use this excel file (https://canvas.ubc.ca/courses/123136/files/29365439?wrap=1) (https://canvas.ubc.ca/courses/123136/files/29365439/download?download_frd=1) for this Breakout Room Exercise. 2 pts Question 1 Final game in each World Cup final (in B column) is in the format of <Winner>-<Runner-up>. For example, B2 is Uruguay-Argentina as Uruguay won the against Argentina in 1930. You want to write a formula in N2 to convert the final game in B2 to the format of <Winner>< versus ><Runner-up>. Hence the output in N2 should be Uruguay versus Argentina . You will copy N2 to the rest of the column N. Please complete the formula in N2. = (B2,"-"," "&" "&" ") Note: " " is a text (i.e., string) with a single blank. 2 pts Question 2 Final score in each World Cup final (in G column) is in the format of <Winner's score>-<Runner-up's score>. For example, G2 is 4-2 as Uruguay scored 4 goals and Argentina scored 2 goals in 1930. You want to write a formula in O2 to convert the final game's score in G2 to the format of <Winner's score> , <Runner- up's score>. Hence the output in O2 should be 4,2 . You will copy O2 to the rest of the column O. Assume that no team has scored more than 9 goals in any final game. Please complete the formula in O2. = (G2, ,1," ") 2 pts Question 3 It is possible for a host country to lose a final game, meaning the host country can be the runner-up. You have decided to create a column named Lost_at_home to reflect this scenario. To achieve this, you enter the following formula in P2 and dragged it down to P23.
Not saved =IF( XXX(SUBSTITUTE(K2, XXX,"")) <> LEN(K2),1,0) This column will display 1 if the host country lost the final game, and 0 otherwise. Please complete the formula in P2. Fill in each blank with only a function name or a cell reference. You can use either a function name or a cell reference in each cell. The use of the $ symbol is not allowed. =IF( (SUBSTITUTE(K2, ,"")) <> LEN(K2),1,0) 2 pts Question 4 The following formula is entered in a blank cell. Upon successful execution, it yields TRUE =REPLACE("Brazil", ___, ___,"Formidable ")="Formidable Brazil" Complete the formula using numbers. Note that there is a single blank space at the end in text "Formidable " in the formula. =REPLACE("Brazil", , ,"Formidable ")="Formidable Brazil" 2 pts Question 5 The following formula is entered into a blank cell: =CONCATENATE( ___," was split into two independent countries: ",LEFT( ___,5)," Republic and S",RIGHT( ___,7)," in 1993.") When the formula is executed, it returns: Czechoslovakia was split into two independent countries: Czech Republic and Slovakia in 1993. Complete the formula by filling the blanks. You can only use cell references. Do not use $ sign . =CONCATENATE( ," was split into two independent countries: ",LEFT( ,5)," Republic and S",RIGHT( ,7)," in 1993.") Submit Quiz
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help