USING MICROSOFT EXCEL
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: -In cell B2, type =PROPER(A2), then press Enter. This formula converts the name in cell A2 from uppercase to proper case. 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: -UPPER Function – How to Convert Text to All Capital Letters. The UPPER Function[1] is an Excel Text function, that will convert text to all capital letters (UPPERCASE). Thus, the function converts all characters in a supplied text string into upper case.
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.