Question

column a contains 12 student names. column b contains each students weight. which formula would calculate the average weight of all 12 of the students? a average(a1:b12) b max(b2:b6) c count(b1:b12) d average(b1:b12)

Explanation:

Step1: Identify target data

Weights are in Column B (12 entries: B1-B12).

Step2: Select correct function

AVERAGE() calculates mean; range B1:B12 covers all weights.

Step3: Eliminate wrong options

A mixes names/weights; B finds max (not avg); C counts entries (not avg). Only D works.

Answer:

D. AVERAGE(B1:B12)