Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.4 Format and Modify Text with Functions: UPPER


Formulas -> Function Library-> Text ->UPPER

TEXT Functions: UPPER

Look at the text in any spreadsheet. The data entry may not be consistent. Some people never use capital letters, and some folks make every word begin with a capital letter.

You can create a formula that formats the Text: UPPER, LOWER, PROPER.


1. Try It: Add a Label

Go to the Text Functions spreadsheet.

Select Cell G1.

Type the label: UPPER


2. Try It: Use the UPPER Text Function

Select Cell G2.

Go to Formulas->Function Library-> Text.

Click on UPPER.


Keep going, please.