What tool is used to split the window into different parts of the same worksheet?

When you insert a row, you have to reset all the equation references because:

Which keyboard shortcut pastes copied information?

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:

Which chart type provides the best visual display of the relationship between two numeric variables?

What ribbon command on the Home tab can you use to change a cell's fill color automatically, based on the value of the cell?

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

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

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