Test yourself
Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.
Which function would you use to change text to initial capital letters?
PROPER
UPPER
LOWER
Which paste option on the Paste button would remove the formula?
Formulas
Values
You want to use a nested formula to fix both incorrect capitalization and extra spaces at the same time in cell A2. This is how to type the formula in another cell: =PROPER(TRIM(A2)
True.
False.
In the practice, you learned how to change text to no capitals. To do that, you use the _____ function.
TRIM.
LOWER.
UPPER.
