DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
UPPER
|
|
|
PROPER
|
|
|
LOWER
|
|
|
SUBSTITUTE
|
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.
Detailed explanation-2: -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.
Detailed explanation-3: -The PROPER function will help us convert text into the proper case, if required. We can use it to capitalize each word in a given string. Using the function will not affect numbers and punctuations.
Detailed explanation-4: -Just remember the upper function converts text to upper case, the lower function converts all text to lower case, and the proper function capitalizes the first letter of the word, while changing the remaining letters to lower case.