A formula in Excel that works to change the initial letter of a word to capital

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

A	UPPER
B	LOWER
C	PROPER
D	MAX

Explanation:

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 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. The last way to capitalize in Excel shortcut is to use the ‘Paste Special’ feature.

Detailed explanation-3: -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.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL