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

CONCATENATE(string1, string2, ...) combines multiple text values into a single string without adding any separator.

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

LEFT(text, num_chars) returns the specified number of characters starting from the beginning (left side) of a text string.

Question 3

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

Accepted Answer

UPPER()

Answer

UPPER(text) converts every alphabetic character in the text string to its uppercase equivalent.

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

TRIM(text) removes spaces from the beginning and end of a string and reduces multiple consecutive internal spaces to a single space.

Question 5

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

Accepted Answer

FIND()

Answer

FIND(search_for, text_to_search, [starting_at]) returns the character position where the search string first appears, and it is case-sensitive.

Google Sheets Test Practice Test