Question

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.

Answer 1

In Excel, the COUNT function is used in cell S6 with the formula '=COUNT(B6:M6)' to count cells with numbers, and the COUNTBLANK function in cell T6 with the formula '=COUNTBLANK(B6:M6)' to count empty cells. AutoFill can extend these formulas down the sheet.

Step-by-step explanation:

To count the number of cells containing numbers in a range from B6 through M6 in Excel, you would use the COUNT function. The formula in cell S6 would be =COUNT(B6:M6). This function counts the number of cells that contain numeric values within the specified range.

Similarly, to count the number of empty cells in the same range, you would use the COUNTBLANK function. The formula in cell T6 would be =COUNTBLANK(B6:M6). This function counts the number of empty cells within the specified range.

To AutoFill both formulas down through all of the morning classes, you would select cells S6 and T6, and then drag the fill handle (a small square at the bottom-right of the cell highlight) down through the desired range.