Which of the following function in MS-Excel 2010 converts a text string to all lowercase letters?

Correct option is B

Correct Answer: B) LOWER
Explanation:
· The LOWER function in MS-Excel 2010 is designed to convert all uppercase letters in a text string to lowercase.
· It only affects alphabetic characters; numbers, punctuation, and special symbols within the text string remain unchanged.
· The syntax for the function is: =LOWER(text).
Information Booster:
· This function is particularly useful when dealing with large datasets where text needs to be standardized, such as converting a list of mixed-case email addresses into a uniform lowercase format for easier sorting or searching.
· Like most text functions, it is non-destructive, meaning it does not change the original cell but provides the result in the cell where the formula is entered.
Additional Knowledge:
· PROPER: This function capitalizes the first letter of every word in a text string and converts all other letters to lowercase (e.g., "INDIAN HISTORY" becomes "Indian History").
· UPPER: This function is the opposite of LOWER; it converts every letter in a text string to its uppercase equivalent (e.g., "excel" becomes "EXCEL").
· TEXT: This function allows you to change the way a number or date appears by applying formatting to it with format codes (e.g., converting a date into a specific "dd-mm-yyyy" string format).