When preparing a spreadsheet that contains population data for different nations, what is the best way to provide a visual comparison of the nations’ population sizes?
Answer
A
apply a yellow background color to the spreadsheet
B
enter a formula to yield total populations for each nation
C
create a bar graph that shows population totals for each nation
D
use the AVERAGE function to calculate the average population size of a nation
Explanation
A bar graph makes it easy to compare the population totals of different nations visually. Each nation gets a bar, and the bar lengths show the relative population sizes. Adding color or calculating totals or averages does not provide the same direct visual comparison.
AI-written and checked against the verified answer.