M6 L1 Quiz

The data in H2 is I like strawberries. What would the result be for the function =LEFT(H2,4)?

• I lik

• I like

• I li

• I like s

The data in J2 is the Zip Code 43892-3424. What would the result be for the function =MID(J2,7,4)?

• -342

• -34

• 3424

• 424

There are _______________ characters in the Zip Code 45392-2342.

• 7

• 8

• 9

• 10

If the data in I2 is 345-555-0125, which of the following would result in the data 555 being extracted?

• =LEFT(I2,3)

• =RIGHT(I2,8)

• =MID(I2,5,3)

• =LEFT(I2,LEN(I2)-5)

Which of the following would be an example of the result after using the UPPER function?

• guy rabin

• GUY RABIN

• gUY rABIN

• Guy Rabin

Cell A2 contains the first name and B2 contains the last name. Which of the following is the correct formula to combine both the first and last name?

• =CONCAT(A2," ",B2)

• =TEXTJOIN(A2:B2,false," ")

• =COMBIN(A2," ",B2)

• Use =A2 + " " + B2

Cell A1 contains the area code for a phone number. Cell B1 contains the seven-digit phone number with a dash separating the third and fourth numbers. What would be the result of the formula =TEXTJOIN(A1:B1,true," ")?

• 555-345-0162

• 555 345 0162

• 555-345 0162

• 555 345-0162

Which of the following can be used as a delimiter within a TEXTJOIN function?

• A space

• A comma (,)

• A dash (-)

• All the above

A school secretary has an Excel file containing parents' and guardians' names and the names of the students who live with them. This information needs to be combined so that a list can be created connecting the students with the parents or guardians they live with in the same household. Remembering that there might be more than one guardian in the household and might be more than one student living in the same household, which function would be best to use in this situation?

• CONCAT, using a delimiter of a space

• TEXTJOIN, using true and a comma with a space as a delimiter

• TEXTCOMB, using a comma delimiter

• TEXTJOIN, using false and a comma as a delimiter

To combine text from one cell with another cell, use the __________ function.

• CONCAT

• UPPER

• LOWER

• TEXTJOIN