DATABASE FUNDAMENTALS
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.
|
|
=LOWER
|
|
|
=UPPER
|
|
|
=MID
|
|
|
=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.
There is 1 question to complete.