10
AssignmentMultiple Choice

Spreadsheet Basics

Question 10 • AL-Career Preparedness

You are preparing a spreadsheet that contains population data for each nation. How can you present your data to provide a visual comparison of the differences in population between nations?

Answer
A
Enter a formula to yield total populations for each nation.
B
Apply a yellow background color to your spreadsheet.
C
Use the AVERAGE function to calculate the average population per nation.
D
Create a bar graph showing population totals for each nation.

Explanation

A bar graph displays each nation’s population as a bar, so the bar lengths make it easy to compare population differences visually. The correct choice is to create a bar graph showing population totals for each nation. Formulas and averages calculate values, while a background color does not show how populations compare.

AI-written and checked against the verified answer.

Previous
Next