How do you remove everything (values, formatting, etc.) from a cell?

What is the difference between a workbook and a worksheet?

Which formula contains a valid absolute reference?

Cell A1 contains the number 3. Which formula returns the text Apple?

How would you search an entire workbook with Find & Select?

To split text across cells without using Merge & Center, click Formt Cells. The, on ** Alignment** tab, click**_**.

Pressing CTRL-Home moves the cursor to:

In which tab is the page breaks preview located?

The Freeze Panes function allows the user to:

To create another worksheet that is exactly the same as the current worksheet you would...

You have a table of data listing each sales person in one column and their territory in a second column. Each sales person is only listed once but there are hundreds of sales people. What function could you use to quickly display a salesperson's territory by typing in their name?