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.
