USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
LOWER
|
|
|
UPPER
|
|
|
PROPER
|
|
|
IF
|
Detailed explanation-1: -Tip: Use the formula =UPPER(A1) for all UPPERCASE; =LOWER(A1) for all lowercase.
Detailed explanation-2: -Select the “Formulas” tab > Select the “Text” drop-down list in the “Function Library” group. Select “LOWER” for lowercase and “UPPER” for uppercase. Next to the “Text” field, click the spreadsheet icon. Click the first cell in the row or column that you would like to change the text case.
Detailed explanation-3: -In the Style dialog box, click the Format button. In the Format Cells dialog box, select the Font tab and set the font to the desired ALL CAPS font. You can also use this opportunity to set the font color, underline color, border color, etc…
Detailed explanation-4: -Then, press the Ctrl + Shift + U keys on your keyboard. This shortcut will instantly convert the text in the selected cells to uppercase letters. If you want to convert text to lowercase letters, you can use the Ctrl + Shift + L shortcut.
Detailed explanation-5: -Description. Converts all uppercase letters in a text string to lowercase.