BG5

.pdf

School

University of British Columbia *

*We aren’t endorsed by this school

Course

COMM 205

Subject

Mathematics

Date

Apr 3, 2024

Type

pdf

Pages

2

Uploaded by ColonelTapir3322

Report
Breakout Group (BG) 5 Due Mar 4 at 11p.m. Points 10 Questions 3 Available Mar 4 at 9a.m. - Mar 4 at 11:59p.m. 14 hours and 59 minutes Time Limit None Allowed Attempts Unlimited Instructions This quiz was locked Mar 4 at 11:59p.m.. Attempt History Attempt Time Score LATEST Attempt 1 27 minutes 3 out of 10 Correct answers are no longer available. Score for this attempt: 3 out of 10 Submitted Mar 4 at 11:40a.m. This attempt took 27 minutes. IncorrectQuestion 1 0 / 3 pts Answer 1: text (i.e. string) number logical error 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/129850/files/29132765?wrap=1) (https://canvas.ubc.ca/courses/129850/files/29132765/download?download_frd=1) for this breakout room exercise. The following formula is executed in a blank cell in World Cup tab of the excel file provided. =MID(C2,1,1) The data type of the output in that cell is number .
IncorrectQuestion 2 0 / 4 pts Answer 1: (You left this blank) Answer 2: C2 Answer 3: 1994 =CONCATENATE(VLOOKUP(A26,A2:C22,2,FALSE)," ","won the cup in"," ",A26,".") Question 3 3 / 3 pts True False Quiz Score: 3 out of 10 You want to write a formula in B26 to return a sentence which tells which country won the cup in the year provided in A26. For example, if you type 1994 in A26, the output in B26 is the following text. Brazil won the cup in 1994. The formula in B26 is provided with some parts redacted. = XXXX(VLOOKUP(A26,A2:C22, XXXX,FALSE)," ","won the cup in"," ", XXXX,".") Please complete the formula below: = (VLOOKUP(A26,A2:C22, C2 ,FALSE)," ","won the cup in"," ", 1994 ,".") Note that there are two cases where " " is used. " " is a string consisting of a single blank space. You can only use a function name, number, or cell reference in a given blank. Don't leave any space or use $ in you formula. T/F To answer the above question, one can also use the following formula. =VLOOKUP(A26,A2:C22,2,FALSE)&" "&"won the cup in"&" "&A26&"."
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