The data provided on the UnitsSold worksheet required some cleaning before it could be analyzed to calculate the estimated annual demand. What text functions did you use to clean the data? Explain how you knew which text functions to use

What will be an ideal response?

The following functions were used to clean the data on the UnitsSold worksheet: CLEAN, TRIM, LEFT, and VALUE. Since the data included various nonprintable characters the CLEAN function had to be used in order to remove them. The data also included spaces before the number of units so the TRIM function was used to remove any excess spaces. The LEFT function was used in order to extract the 2 character unit count from the word "units". Lastly, since the data was a text value the VALUE function had to be used to convert the text to a number in order to be able to calculate the average.