FUNDAMENTALS OF COMPUTER

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. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference.

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, whose purpose of existence is to capitalize the first letter of each word. Suppose you have a dataset as shown below and you want to quickly convert the first letter of each word into upper case. This would capitalize the first letter of each word in the referenced cell. Pretty straight forward!

Detailed explanation-4: -To do this, simply select the cell or range of cells that you want to change, then press the ‘Ctrl+Shift+U’ keys on your keyboard. This will change all of the letters in the selected cells to uppercase.

Detailed explanation-5: -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…