1 Basic Formulas

Calculate the total for cells B4, B5, and B6 in cell B8. AutoFill that total through cell M8. Then, in cell B9, calculate the sales tax through the rate in cell Q2. AutoFill those values through to cell M9.

1. Click in cell B8
2. Type: =B4+B5+B6
3. Click the fill handle in cell B8 and drag it through cell M8
4. Click in cell B9
5. Type: =B8*$Q$2
6. Click the fill handle in cell B9 and drag it through cell M9

2 Named Ranges In Formulas

​In cell B9, multiply the contents of cell B8 and the named range, TaxRate. Then, AutoFill the formula to cell M9.

1. Click in cell B9
2. Type: =B8 * TaxRate
3. Click the fill handle in cell B9 and drag it through cell M9

3 Basic Functions

Below each of the headings for Sum, Average, Min, and Max, add functions to get the sum, average, maximum, and minimum values for cells B6 through M6. Then, AutoFill the results down through all of the morning classes.

1. Click in cell O6
2. Type: =SUM(B6:M6)
3. Click in cell P6
4. Type: =AVERAGE(B6:M6)
5. Click in cell Q6
6. Type: =MIN(B6:M6)
7. Click in cell R6
8. Type: =MAX(B6:M6)
9. Select cells O6 through R6
10. Click the fill handle and drag down through row 20

4 Count Functions

​In cell S6, use a function to display a count of the cells from B6 through M6 that contain a number. In cell T6, use a function to display a count of the cells from B6through M6 that contain nothing. AutoFill both cells down through all of the morning classes.

1. Click in cell S6
2. Type: =COUNT(B6:M6)
3. Click in cell T6
4. Type: =COUNTBLANK(B6:M6)
5. Select cells S6 and T6
6. Click the fill handle and drag down through row 20

5 If Functions

In cell Q2, insert a function that displays a YES if the total number of morning classes for January is at least 175 and a NO if not.

1. Click in cell Q2
2. Click the Formulas tab
3. In the Function Library group, click the Logical drop-down arrow
4. Click IF
5. In the Logical_test field type: SUM(S6:S20)>=175
6. Click in the Value_if_true field
7. Type: YES
8. Click in the Value_if_false field
9. Type: NO
10. Click the OK button