FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which formula can NOT be used to change text case?
A
UPPER
B
MIDDLE
C
LOWER
D
PROPER
Explanation: 

Detailed explanation-1: -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-2: -You may use “&” to put formula between a sentence. Put the text in inverted commas “” and add & then add formula. One example is as follow of a statement showing total quantity. you may add more text after formula by adding & sign and then text in “”.

Detailed explanation-3: -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.

There is 1 question to complete.