Text Function Group - G8 Maya School

What does the TRIM function remove from a text string?

• Special characters
• Spaces between words
• Leading and trailing spaces
• Leading and trailing characters

What does the LEFT function in Excel do?

• Converts text to proper case

• Removes extra spaces from text

• Extracts a specified number of characters from the beginning of a text string

• Converts text to lowercase

What does the TRIM function in Excel do?

• Converts text to proper case

• Removes extra spaces from text

• Extracts a specified number of characters from the beginning of a text string

• Converts text to lowercase

The MID function is used to:

• Remove extra spaces from text

• Convert text to proper case

• Extract a specified number of characters from a text string

• Convert text to lowercase

Which function is used to convert all letters in a text string to lowercase?

• LEFT

• RIGHT

• LOWER

• PROPER

The formula =UPPER(A1) converts:

• Text to lowercase

• Text to uppercase

• Text to proper case

• Text to trimmed version

What is the purpose of the LEFT function in Excel?

• Converts text to proper case

• Extracts characters from the beginning of a text string

• Converts text to uppercase

• Counts the number of characters in a text string

What does the LEN function in Excel do?

• Converts text to lowercase

• Removes extra spaces from text

• Counts the number of characters in a text string

• Extracts a specified number of characters from a text string

The formula =RIGHT(A1, 4) extracts:

• The first 4 characters from the left side of cell A1

• The last 4 characters from the right side of cell A1

• The characters before the last space in cell A1

• The characters in lowercase from cell A1

The formula =LEFT(A1, 3) extracts:

• The first 3 characters from the left side of cell A1

• The last 3 characters from the right side of cell A1

• The characters after the first space in cell A1

• The characters in uppercase from cell A1