Changing Text Case in Microsoft Excel

This video tutorial demonstrates how to change text case in Microsoft Excel using formulas. It covers converting text to lowercase, uppercase, and proper case. The tutorial explains how to use the LOWER, UPPER, and PROPER functions, and how to paste values to replace formulas with editable text. Although Excel lacks a sentence case function, the video provides a workaround by manually adjusting capital letters.

What function is used in Excel to convert text from uppercase to lowercase?

• SENTENCE

• PROPER

• LOWER

• UPPER

After converting text to lowercase using a formula, what is the next step to replace the original text?

• Save the document

• Use the 'UNDO' function

• Paste the formula result as values

• Delete the original text

Which function in Excel is used to convert text to uppercase?

• CAPITALIZE

• UPPER

• PROPER

• LOWER

What does the 'PROPER' function do to the text in Excel?

• Capitalizes the first letter of each word

• Converts all text to lowercase

• Converts all text to uppercase

• Converts text to sentence case

Which text case conversion function is missing in Excel?

• Uppercase

• Title case

• Sentence case

• Lowercase