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.