Upper Case converts the selected range to all uppercase text, i.e. THE QUICK BROWN FOX.
Lower Case converts the selected range to all lowercase text, i.e. the quick brown fox.
Capitalise converts the selected range to an initial capital letter followed by all lower case letters, i.e. The quick brown fox.