Recall & Review
beginner
What does the LEFT function do in Google Sheets?
The LEFT function extracts a specified number of characters from the start (left side) of a text string.
Click to reveal answer
beginner
How do you use the RIGHT function?
RIGHT(text, number) extracts a specified number of characters from the end (right side) of the text string.
Click to reveal answer
beginner
Explain the MID function in simple terms.
MID(text, start_position, number_of_characters) extracts characters from the middle of a text string, starting at the position you choose.
Click to reveal answer
beginner
Example: What is the result of =LEFT("Banana", 3)?
The result is "Ban" because it takes the first 3 letters from the left of "Banana".
Click to reveal answer
beginner
Example: What does =MID("Spreadsheet", 6, 4) return?
It returns "dshe" because it starts at the 6th character and takes 4 characters from "Spreadsheet".
Click to reveal answer
What does =RIGHT("Hello", 2) return?
✗ Incorrect
RIGHT("Hello", 2) takes the last 2 characters from "Hello", which are "lo".
Which function extracts characters from the middle of a text string?
✗ Incorrect
MID extracts characters starting at any position inside the text.
What will =LEFT("Google", 0) return?
✗ Incorrect
LEFT with 0 characters returns an empty string.
If you want the last 4 letters of "Spreadsheet", which formula do you use?
✗ Incorrect
RIGHT("Spreadsheet", 4) returns the last 4 letters.
What does =MID("Example", 3, 2) return?
✗ Incorrect
MID starts at the 3rd character and takes 2 characters: "mp".
Describe how you would extract the first 5 characters from a text string in Google Sheets.
Think about taking characters from the start of the text.
You got /3 concepts.
Explain the difference between LEFT, RIGHT, and MID functions.
Consider where in the text each function takes characters.
You got /3 concepts.