USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
first letter is upper case and the remaining letters are lower case
|
|
|
none of the above
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Description. Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
Detailed explanation-2: -str to title() Function in R Language is used to convert the first letter of every word of a string to Uppercase and the rest of the letters are converted to lower case. Note: This function uses ‘stringr’ library.
Detailed explanation-3: -The Upper function converts all letters to uppercase (capital letters). The Lower function converts all letters to lowercase. The Proper function capitalizes the first letter in each word and converts all other characters to lowercase.
Detailed explanation-4: -One good example is the PROPER function, which capitalizes the first letter of every word in a cell. If you have cells containing proper nouns, like names or titles, you can use the PROPER function to make sure everything is capitalized correctly.
Detailed explanation-5: -The proper() function makes the first letter of each word capitalized and leaves the other letters lowercase (Proper Case). All three of these options work on the same principle, so I’ll show you how to use one of them. Let’s take the Excel uppercase function as an example.