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 splits a text string into separate pieces based on a delimiter?
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.
What does the SUBSTITUTE function do in Google Sheets?
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.
Which function converts a number to a text string using a specified format in Google Sheets?
Answer: TEXT()
TEXT(number, format) converts a numeric value to text using a format pattern like "#,##0.00" or "MM/DD/YYYY".
What does the MID(text, start, num_chars) function extract in Google Sheets?
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.
Which function removes non-printable characters from a text string in Google Sheets?
Answer: CLEAN()
CLEAN(text) removes characters that cannot be printed, such as control characters often found in text imported from other applications.
What does the PROPER() function do to a text string in Google Sheets?
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.
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