Google Sheets Test Google Sheets Text Functions Questions and Answers 3

Question 1

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

Accepted Answer

TEXTJOIN()

Answer

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

Question 2

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

Accepted Answer

Repeats a text string a specified number of times

Answer

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

Question 3

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

Accepted Answer

REPLACE()

Answer

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

Question 4

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

Accepted Answer

A text string representing a number into a numeric value

Answer

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.

Question 5

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

Accepted Answer

RIGHT()

Answer

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

Google Sheets Test Practice Test