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