DATABASE FUNDAMENTALS
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: -Type =PROPER(A2), and press Enter. 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: -Description. Converts all uppercase letters in a text string to lowercase.
Detailed explanation-5: -To use a keyboard shortcut to change between lowercase, UPPERCASE, and Capitalize Each Word, select the text and press SHIFT + F3 until the case you want is applied.