Excel Certification Practice Exam 2025 – Comprehensive Study Guide

To convert text that is in uppercase to lowercase in Excel, the appropriate function to use is the LOWER function. This function specifically takes a string of text as an argument and returns the same string with all uppercase letters converted to their lowercase counterparts.

For instance, if you apply the LOWER function to the text "HELLO", it will produce "hello". This makes the LOWER function ideal for situations where consistent case formatting is necessary, such as preparing data for analysis or reporting.

The other functions listed serve different purposes. For example, the UPPER function is designed to convert lowercase letters to uppercase, while the PROPER function capitalizes the first letter of each word in a string but does not affect the case of letters that are already in uppercase. The CONCATENATE function is used to join two or more strings together and does not change the case of the text. Thus, the correct choice is to use the LOWER function for converting uppercase text to lowercase.