LEFT_RIGHT_MID Excel Functions Quiz

What does the LEFT function do in Excel?

• Extracts a specified number of characters from the right of a text string.

• Extracts a specified number of characters from the middle of a text string.

• Extracts a specified number of characters from the left of a text string.

• Reverses the text string.

Which of the following formulas will return "Hel" from the text "Hello World"?

• =LEFT("Hello World",3)

• =RIGHT("Hello World",3)

• =MID("Hello World",1,3)

• =MID("Hello World",2,3)

What does the RIGHT function return when applied to the text "Excel" with the number 2?

• "El"

• "Ex"

• "ce"

• "el"

What does the formula =MID("12345", 2, 3) return?

• "12"

• "234"

• "345"

• "23"

Which of the following best describes the MID function in Excel?

• Extracts characters from the right of a string.

• Extracts characters from the left of a string.

• Extracts characters from the middle of a string, starting at a specified position.

• Extracts the first character of a string.

What does the formula =LEFT("OpenAI", 4) return?

• "Open"

• "AI"

• "pen"

• "Ope"

Which formula would you use to extract the last three characters of the text "Data Analysis"?

• =LEFT("Data Analysis",3)

• =MID("Data Analysis",3,3)

• =RIGHT("Data Analysis",3)

• =RIGHT("Data Analysis",4)

If you use =MID("Excel", 1, 2), what will be the result?

• "Ex"

• "Ec"

• "ce"

• "El"

How can you use the LEFT function to extract the first character of a string?

• =LEFT(A1,1)

• =MID(A1,2,1)

• =RIGHT(A1,1)

• =MID(A1,1,2)

What will the formula =RIGHT("ABCDE", 0) return?

• "A"

• "ABCDE"

• Blank (empty string)

• Error