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**_**.

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?

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

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?

Which keyboard shortcut pastes copied information?

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