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



UPPER Text Arguments

3. Try This: Edit the Function Arguments

Edit the Text:B2.


You should see a preview of the data in all capital letters, "PIGS".

Click OK.


Try This, Too: AutoFill the Formula

Use the AutoFill handle to fill down this formula in Column G.


Memo to Self: The LOWER text function converts the text to all lowercase letters.


The PROPER Text function begins each word with a capital letter.


Formulas -> Function Library-> Text ->UPPER