USING MICROSOFT EXCEL
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: -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. It will convert all other letters to lowercase.
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: -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.
Detailed explanation-4: -The LOWER function changes any uppercase letters in a text string to lowercase.