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?

To ensure that a collection of shapes are evenly spaced apart from left to right, select the shapes, click Page Layout > Align, and then click _.

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:

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