Page 15 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 compare cell contents?

LEN

TRIM

EXACT

Which operator could be used to combine text from multiple cells into one cell?

$

&

%

To combine the text from cell A2 (Nancy) and cell B2 (Davolio), so that the name is displayed in one cell as Nancy Davolio, you would type this formula in another cell: =A2&" "B2

True.

False.

In the practice, you learned how to reverse name order, to combine text from cell A2 (Nancy) and cell B2 (Davolio), so that the name is displayed in cell C2 as Davolio, Nancy. You would type this formula: =B2&","&A2

True.

False.

Page 15 of 23PREVNEXT