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?

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

The Freeze Panes function allows the user to:

In which tab is the page breaks preview located?

Pressing CTRL-Home moves the cursor to:

Identify the error: When entering 325 in a cell, the result shows up as 3.25.

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

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

Which formula contains a valid absolute reference?

What is the difference between a workbook and a worksheet?

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