Cell A1 contains the string " Tom Jones" (two blank spaces before the name Tom). To remove the two blank spaces, the formula is:

When a cell is entered in a formula without using the $ symbol, what type of reference occurs?

If A1=6 and B1=4, then what is =A1&B1?

A 'frequency distribution' is a summary table that shows the frequency of each value in a ___?

What function would you use to extract a portion of a text string from the center of the string?

Cell A1 has the number '3' in it. Cell A2 has the value '5' in it. If you merge these two cells together, what is left in the merged cell?

The advanced filter tool can ________.

The ________, when outlined in black, indicates it is ready to accept data.

The ________ group on the design tab is useful for adjusting the data source of a chart.

The ________ displays the current cell mode, the page number, and the zoom buttons.

The _____ error value means that a value is not available to a function or formula.