Google Sheets Text Functions Quiz

Which function in Google Sheets capitalizes the first letter of each word?

• CAPITALIZE

• UPPER

• LOWER

• PROPER

What is the purpose of the trim function in Google Sheets?

• To split text

• To find and replace text

• To capitalize text

• To remove extra spaces

How can you make a find and replace operation case-sensitive in Google Sheets?

• By using the PROPER function

• By using the CONCATENATE function

• By checking the 'Match case' option

• By using the UPPER function

Which function allows you to join text with a single delimiter between each argument?

• CONCATENATE

• TEXTJOIN

• JOIN

• SPLIT

What is the advantage of using the TEXTJOIN function over the JOIN function?

• It can capitalize text

• It can ignore empty cells

• It can find and replace text

• It can split text

Which function would you use to extract a specific number of characters from the left side of a text string?

• EXTRACT

• MID

• RIGHT

• LEFT

What wildcard character can replace any number of characters in a Google Sheets function?

• ~

• *

• ?

• #

Which function is used to extract characters from the middle of a text string?

• LEFT

• RIGHT

• MID

• CENTER

In the context of Google Sheets, what does the asterisk (*) wildcard do?

• Replaces only numbers

• Replaces any number of characters

• Replaces a single character

• Replaces only letters

Which function would you use to count the number of cells that meet a certain criterion using wildcards?

• SUMIF

• AVERAGEIF

• COUNTIF

• FILTER