Google Sheets Test Google Sheets Text Functions Questions and Answers 2

Question 1

Which Google Sheets function splits a text string into separate pieces based on a delimiter?

Accepted Answer

SPLIT()

Answer

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?

Accepted Answer

Replaces all occurrences of one text segment with another

Answer

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?

Accepted Answer

TEXT()

Answer

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?

Accepted Answer

A substring starting at a given position for a specified length

Answer

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?

Accepted Answer

CLEAN()

Answer

CLEAN(text) removes characters that cannot be printed, such as control characters often found in text imported from other applications.

Google Sheets Test Practice Test

Google Sheets Test Practice Test

Google Sheets Test Google Sheets Text Functions Questions and Answers 2