DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
LOWER
|
|
|
UPPER
|
|
|
PROPER
|
|
|
None of the above
|
Detailed explanation-1: -The UPPER function syntax has the following arguments: Text Required. The text you want converted to uppercase. Text can be a reference or text string.
Detailed explanation-2: -The UPPER() function converts a string to upper-case.
Detailed explanation-3: -To convert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference.
Detailed explanation-4: -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.