a. The standard states that cells with a value equal to 0 are included in the calculation.
Office returns #NUM! if the value of any data point is less than or equal to 0.