Page 22 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.


From "10249 Tofu $18.60", which function would find and display "10249"?

RIGHT

LEFT

EXACT

Which function finds the length of text?

LEN

FIND

LEFT

This formula, =LEFT(A2,FIND(" ",A2)-1), separates the first name from the last name in a cell and enters the first name into a cell of its own. Which part of the formula looks for the space between the first and last names?

LEFT.

FIND.

The space between the quotation marks.

In the practices, you learned how to delete formulas. You can delete formulas from more than one column at a time.

True.

False.

Page 22 of 23PREVNEXT