Question

the formula calculating the average doors knocked per day in cell j4 includes the range for both doors knocked (c10:c53) and doors answered (d10:d53). what range should be used in the average function in cell j4?
c10:d53
d10:d53
c10:c53

Explanation:

Step1: Identify data for average

To find the average of doors knocked per day, we need all relevant data. The data for doors knocked is in C10:C53 and for doors answered is in D10:D53. We want to include both sets of data for the average calculation.

Step2: Determine range for AVERAGE function

The combined range that includes both doors knocked and doors answered data is C10:D53.

Answer:

A. C10:D53