Understanding Charts and Data

Why would you use a chart instead of a table to show data?

• Charts take less time to create than tables

• Charts are easier to decorate with colors

• Charts help you understand data patterns more quickly

• Tables are not allowed in math assignments

Hepzibah wants to find out which subject her class likes most. She collects answers and puts them in a chart. Which chart would best show the number of students per subject?

• Line chart

• Pie chart

• Bar chart

• Scatter plot

If you used conditional formatting to highlight all scores below 50 in red, what is the main purpose of doing this?

• To make the spreadsheet look colorful

• To make it easier to see low scores that may need attention

• To reward students with low scores

• To delete those numbers automatically

A class uses a spreadsheet to track how many books each student read. If they use a color scale conditional formatting, what does it help them see?

• Which students read in alphabetical order

• Which student has the longest name

• Which students read the most or fewest books

• Who submitted their list first

Glory used a pie chart for her science project, but her teacher couldn't see the differences between the slices clearly. What could Glory do to make the data clearer?

• Use a line graph instead

• Change the colors of the slices

• Make all slices the same size

• Remove the labels from the slices

Why would you use conditional formatting to highlight numbers in a spreadsheet?

• To sort the numbers automatically

• To hide the numbers

• To draw attention to specific data

• To make the file larger

Which of these is a good reason to use a color scale in conditional formatting?

• To decorate the page

• To help find patterns in the data

• To make the background colorful

• To delete wrong numbers

You want to quickly find all the scores above 90 in a list. Which tool should you use?

• Line graph

• Conditional formatting

• Bar chart

• Data sort

What type of chart is best for showing changes in temperature over a week?

• Pie chart

• Line graph

• Bar chart

• Column chart

In a color scale from red to green, what would red likely mean?

• High value

• Middle value

• Low value

• Random value