Question

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?

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

Answer 1

create a bar graph that shows population totals for each nation.

Answer 2

The best answer to the question above would be option C: create a bar graph that shows population totals for each nation. Since it emphasizes a visual comparison, the best way to do this is to create a bar graph. So in a bar graph, the numerical values of the variables are also presented such as the population total of each nation. In addition, the rectangular bars can easily show you the difference between each nation which makes this an ideal visual tool for comparison.