How would you find the absolute value of A1?

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?

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.

The first step in creating an effective worksheet is to make sure you ____.

The default number format is ________.

The advanced filter tool can ________.