Question

how does the average function deal with empty cells and cells containing a zero value? select one: a. it ignores both empty cells and zero values. b. it uses the zero values in the calculation, but ignores the empty cells. c. it uses both empty cells and zero values in the calculation. d. it uses the empty cells, but ignores the zero values in the calculation.

Explanation:

The AVERAGE function in spreadsheet software like Excel includes cells with zero - values in the calculation as they are numerical values, but it ignores empty cells as they have no numerical contribution.

Answer:

B. It uses the zero values in the calculation, but ignores the empty cells.