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?
Which paste option on the Paste button would remove the formula?
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)
In the practice, you learned how to change text to no capitals. To do that, you use the _____ function.