Page 9 of 23PREVNEXT

Use formulas to edit, correct, and proofread text

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.

Page 9 of 23PREVNEXT