MS Excel - August 23, 2025

Which Excel function converts text to all uppercase letters?

• LOWER()
• UPPER()
• PROPER()
• CAPITAL()

Which function converts text to all lowercase letters?

• UPPER()
• LOWER()
• PROPER()
• SMALL()

What does the PROPER() function do?

• Converts all letters to uppercase
• Converts all letters to lowercase
• Capitalizes the first letter of each word
• Removes extra spaces

Which function is used to combine multiple text strings into one?

• CONCAT()
• LEN()
• TRIM()
• LEFT()

The LEN() function in Excel is used to:

• Count cells in a range
• Return the number of characters in a string
• Find text within a cell
• Trim spaces from text

Which function removes extra spaces in a text string?

• CLEAN()
• TRIM()
• LEFT()
• FIND()

What does =LEFT("Excel", 2) return?

• Ex
• El
• L
• Exc

Which function returns the last character(s) in a string?

• RIGHT()
• LEFT()
• MID()
• END()

Which function finds the position of a substring in text?

• MID()
• FIND()
• MATCH()
• SEARCH()

=RIGHT("Excel", 3) returns:

• Exc
• cel
• xel
• el