You have text in Cell B2 which is in Capital Letter and you want to change the text to Small Letter, which of the following will change the text for you? Lower=(B2) =LowerCase(B2) =SmallCase(B2) =Lower(B2)

Which function helps in changing the text to uppercase in Excel?Answer( Please choose a correct answer )   CLEARLOWER()CAPITAL()UPPER()BIG()

What should you do if you have Excel data in all upper-case letters and want to change it to all lowercase?1 pointUse the CHANGE_CASE function.Use the PROPER function.Use the Change Case button.Use the LOWER function.

Which of the following function will change the first letter of every word to Upper Case in excel? FirstUpper Tittle Proper Mid

Suppose you have a string - Hello! HOW are you doing - with cell reference C54. Now you need to convert the first letter of every word as capital and rest characters in lower case.Which of the following is the correct function for the same? Answer choicesSelect only one optionREVISITLOWER(C54)UPPER(C54)PROPER(C54)PROPERL(C54)

When should you use the REPLACE function instead of the SUBSTITUTE function?AWhen you need to replace multiple instances of a specific text.BWhen you want to change the formatting of cells in a worksheet.CWhen you know the exact position and length of the characters to be replaced.DWhen you want to perform calculations based on certain criteria.