Google Sheets Test Google Sheets Text Functions Questions and Answers

Question 1

Which Google Sheets function joins two or more text strings into one?

Accepted Answer

CONCATENATE()

Answer

MERGE()

Answer

CONCAT()

Answer

JOIN()

Question 2

What does the LEFT(text, num_chars) function return in Google Sheets?

Accepted Answer

The first N characters from the left of a string

Answer

The last N characters of a string

Answer

All characters to the left of a space

Answer

The leftmost word in a string

Question 3

Which function converts all letters in a text string to uppercase in Google Sheets?

Accepted Answer

UPPER()

Answer

CAPS()

Answer

CAPITALIZE()

Answer

TOUPPER()

Question 4

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

Accepted Answer

Removes leading, trailing, and extra internal spaces

Answer

Removes all spaces

Answer

Truncates text to a fixed length

Answer

Removes all non-alphabetic characters

Question 5

Which function returns the position of one text string within another string in Google Sheets?

Accepted Answer

FIND()

Answer

POSITION()

Answer

LOCATE()

Answer

INDEX()

Question 6

What does the LEN() function measure in Google Sheets?

Accepted Answer

The number of characters in a string including spaces

Answer

The number of words in a string

Answer

The byte size of a string

Answer

The number of lines in a cell