FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The Excel function that converts all characters in text into lower case
A
=Upper(text)
B
=Lower(text)
C
=SQRT(text)
D
=Power(text)
Explanation: 

Detailed explanation-1: -Tip: Use the formula =UPPER(A1) for all UPPERCASE; =LOWER(A1) for all lowercase.

Detailed explanation-2: -Converts all uppercase letters in a text string to lowercase.

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. Now, fill down the formula in the new column.

Detailed explanation-4: -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-5: -The toLowerCase method converts a string to lowercase letters.

There is 1 question to complete.
Previous
Next