FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Use a function to copy the name from cell A4 and format the name so that all the letters are lowercase.
A
=LOWER
B
=UPPER
C
=MID
D
=PROPER
Explanation: 

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

Detailed explanation-2: -=LOWER(text) This function uses one argument, that is, text. It is a required argument here. It is the text that we wish to convert to lowercase. The function will not change the characters in the text string that are not letters.

Detailed explanation-3: -Simply type =proper( into cell D2. Then click on the poorly-formatted text you want to transform (like cell C2, which contains Beyonce’s name formatted as BEYONCE). Finally, add a ) to complete the function and press Enter on your keyboard.

Detailed explanation-4: -Description. Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.

There is 1 question to complete.
Previous
Next