Question

which formula would calculate the average number of shots taken, as shown in the spreadsheet?
figure a: a spreadsheet
a max(b2:b6)
b average(b2:b6)
c average(a1:a6)
d count(b2:b6)

Explanation:

The question asks for the average number of shots taken. Shots Taken data is in column B, rows 2-6 (B2:B6). The AVERAGE function calculates the mean of a range, which matches the requirement. MAX finds the highest value, COUNT counts entries, and A1:A6 contains non-numeric player names, so only B is correct.

Answer:

B. AVERAGE(B2:B6)