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

CONCATENATE()

Answer

JOIN()

Answer

COMBINETEXT()

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

Reports the number of times text appears in a range

Answer

Replaces repeated text with a single instance

Answer

Returns the last repeated value in a list

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

SUBSTITUTE()

Answer

SWAP()

Answer

REWRITE()

Question 4

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

Accepted Answer

A text string representing a number into a numeric value

Answer

A formula to its computed result

Answer

A date into its serial number

Answer

A boolean into 0 or 1

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

END()

Answer

LAST()

Answer

TAIL()

Question 6

What does the EXACT() function do when comparing two text strings in Google Sheets?

Accepted Answer

Returns TRUE only if both strings match exactly, including case

Answer

Returns the longer of the two strings

Answer

Returns the number of matching characters

Answer

Highlights differences between the strings