Google Sheets Text Functions Questions and Answers Flashcards

Which Google Sheets function joins multiple text values with a specified delimiter between each item?

Answer: TEXTJOIN()

TEXTJOIN(delimiter, ignore_empty, text1, text2, ...) concatenates a list of strings with a separator, optionally skipping empty values.

What does the REPT(text, number_of_repetitions) function do in Google Sheets?

Answer: Repeats a text string a specified number of times

REPT(text, number_of_repetitions) returns the given text repeated the specified number of times in a single string.

Which function replaces a portion of a text string based on character position rather than content in Google Sheets?

Answer: REPLACE()

REPLACE(original_text, start, num_chars, new_text) removes num_chars characters starting at the start position and inserts new_text in their place.

What does the VALUE() function convert in Google Sheets?

Answer: A text string representing a number into a numeric value

VALUE(text) converts a text string that looks like a number—such as "42" or "3.14"—into an actual numeric value that can be used in math formulas.

Which function returns a specified number of characters from the right end of a text string in Google Sheets?

Answer: RIGHT()

RIGHT(text, num_chars) extracts the given number of characters from the end (right side) of a text string.

What does the EXACT() function do when comparing two text strings in Google Sheets?

Answer: Returns TRUE only if both strings match exactly, including case

EXACT(text1, text2) performs a case-sensitive comparison and returns TRUE if the strings are identical, FALSE if they differ in any way including capitalization.