Google Sheets Test Google Sheets Text Functions Questions and Answers 2 — Questions and Answers
Question 1: Which Google Sheets function splits a text string into separate pieces based on a delimiter?
- DIVIDE()
- SPLIT() (Correct answer)
- SEPARATE()
- EXPLODE()
Correct answer: SPLIT()
SPLIT(text, delimiter) divides a text string at every occurrence of the delimiter and distributes the pieces across adjacent cells in a row.
Question 2: What does the SUBSTITUTE function do in Google Sheets?
- Replaces a cell reference with a value
- Replaces all occurrences of one text segment with another (Correct answer)
- Substitutes a formula error with a default value
- Swaps the positions of two cells
Correct answer: Replaces all occurrences of one text segment with another
SUBSTITUTE(text, search_for, replace_with, [occurrence_number]) replaces occurrences of a substring with a new string, optionally targeting only a specific occurrence.
Question 3: Which function converts a number to a text string using a specified format in Google Sheets?
- NUMTEXT()
- FORMAT()
- TEXT() (Correct answer)
- TOTEXT()
Correct answer: TEXT()
TEXT(number, format) converts a numeric value to text using a format pattern like "#,##0.00" or "MM/DD/YYYY".
Question 4: What does the MID(text, start, num_chars) function extract in Google Sheets?
- The middle word of a sentence
- A substring starting at a given position for a specified length (Correct answer)
- Characters between two delimiters
- The median character in a string
Correct answer: A substring starting at a given position for a specified length
MID(text, start, num_chars) returns a substring of the specified length beginning at the character position indicated by start.
Question 5: Which function removes non-printable characters from a text string in Google Sheets?
- SANITIZE()
- CLEAN() (Correct answer)
- STRIP()
- PURGE()
Correct answer: CLEAN()
CLEAN(text) removes characters that cannot be printed, such as control characters often found in text imported from other applications.
Question 6: What does the PROPER() function do to a text string in Google Sheets?
- Validates that text matches a pattern
- Capitalizes the first letter of each word (Correct answer)
- Converts text to proper ASCII encoding
- Removes improper punctuation
Correct answer: Capitalizes the first letter of each word
PROPER(text) converts the first letter of every word to uppercase and the remaining letters to lowercase, producing title case.
Google Sheets Test Google Sheets Text Functions Questions and Answers 2
Which Google Sheets function splits a text string into separate pieces based on a delimiter?