Google Sheets Text Functions Questions and Answers Flashcards
6 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Google Sheets Text Functions Questions and Answers flashcards as text
Which Google Sheets function joins two or more text strings into one?
Answer: CONCATENATE()
CONCATENATE(string1, string2, ...) combines multiple text values into a single string without adding any separator.
What does the LEFT(text, num_chars) function return in Google Sheets?
Answer: The first N characters from the left of a string
LEFT(text, num_chars) returns the specified number of characters starting from the beginning (left side) of a text string.
Which function converts all letters in a text string to uppercase in Google Sheets?
Answer: UPPER()
UPPER(text) converts every alphabetic character in the text string to its uppercase equivalent.
What does the TRIM() function do to a text string in Google Sheets?
Answer: Removes leading, trailing, and extra internal spaces
TRIM(text) removes spaces from the beginning and end of a string and reduces multiple consecutive internal spaces to a single space.
Which function returns the position of one text string within another string in Google Sheets?
Answer: FIND()
FIND(search_for, text_to_search, [starting_at]) returns the character position where the search string first appears, and it is case-sensitive.
What does the LEN() function measure in Google Sheets?
Answer: The number of characters in a string including spaces
LEN(text) returns the total number of characters in a text string, counting letters, numbers, spaces, and special characters.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy