Question

1. the function =average(c2:c11) can be used to do what for the following spreadsheet?

a \t- \t1 \t2 \t3 \t4 \t5 \t6 \t7 \t8 \t9 \t10 \t11
b \trank name \tcharlotte \traleigh \tgreensboro \tdurham \twinston-salem \tfayetteville \tcary \twilmington \thigh point \tconcord
c \tpopulation \t885,708 \t474,069 \t296,710 \t278,993 \t247,945 \t211,657 \t170,282 \t123,784 \t112,791 \t96,341
d \tcounty \tmecklenburg \twake (seat), durham \tguilford \tdurham (seat), wake, orange \tforsyth \tcumberland \twake, chatham \tnew hanover \tguilford, randolph, davidson, forsyth \tcabarrus
options:

• find the average population of the cities
• arrange the rows according to decreasing population size.
• arrange the rows according to increasing population size.
• find the city with the largest population.

Explanation:

The function =AVERAGE(C2:C11) in a spreadsheet is used to calculate the average (arithmetic mean) of the values in the range C2 to C11, which contains the population figures of the cities. Among the options, "Find the average population of the cities" matches the purpose of the AVERAGE function. The other options involve arranging rows (which would use sorting functions, not AVERAGE) or finding the largest population (which would use MAX function, not AVERAGE).

Answer:

Find the average population of the cities