Google Sheets Test Google Sheets Text Functions Questions and Answers 1 — Questions and Answers
Question 1: Which Google Sheets function joins two or more text strings into one?
- MERGE()
- CONCAT()
- CONCATENATE() (Correct answer)
- JOIN()
Correct answer: CONCATENATE()
CONCATENATE(string1, string2, ...) combines multiple text values into a single string without adding any separator.
Question 2: What does the LEFT(text, num_chars) function return in Google Sheets?
- The last N characters of a string
- The first N characters from the left of a string (Correct answer)
- All characters to the left of a space
- The leftmost word in a string
Correct 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.
Question 3: Which function converts all letters in a text string to uppercase in Google Sheets?
- CAPS()
- UPPER() (Correct answer)
- CAPITALIZE()
- TOUPPER()
Correct answer: UPPER()
UPPER(text) converts every alphabetic character in the text string to its uppercase equivalent.
Question 4: What does the TRIM() function do to a text string in Google Sheets?
- Removes all spaces
- Removes leading, trailing, and extra internal spaces (Correct answer)
- Truncates text to a fixed length
- Removes all non-alphabetic characters
Correct 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.
Question 5: Which function returns the position of one text string within another string in Google Sheets?
- POSITION()
- FIND() (Correct answer)
- LOCATE()
- INDEX()
Correct 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.
Question 6: What does the LEN() function measure in Google Sheets?
- The number of words in a string
- The number of characters in a string including spaces (Correct answer)
- The byte size of a string
- The number of lines in a cell
Correct 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.
Google Sheets Test Google Sheets Text Functions Questions and Answers 1
Which Google Sheets function joins two or more text strings into one?