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

DIVIDE()

Answer

SEPARATE()

Answer

EXPLODE()

Question 2

What does the SUBSTITUTE function do in Google Sheets?

Accepted Answer

Replaces all occurrences of one text segment with another

Answer

Replaces a cell reference with a value

Answer

Substitutes a formula error with a default value

Answer

Swaps the positions of two cells

Question 3

Which function converts a number to a text string using a specified format in Google Sheets?

Accepted Answer

TEXT()

Answer

NUMTEXT()

Answer

FORMAT()

Answer

TOTEXT()

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

The middle word of a sentence

Answer

Characters between two delimiters

Answer

The median character in a string

Question 5

Which function removes non-printable characters from a text string in Google Sheets?

Accepted Answer

CLEAN()

Answer

SANITIZE()

Answer

STRIP()

Answer

PURGE()

Question 6

What does the PROPER() function do to a text string in Google Sheets?

Accepted Answer

Capitalizes the first letter of each word

Answer

Validates that text matches a pattern

Answer

Converts text to proper ASCII encoding

Answer

Removes improper punctuation