This quiz is a fun way to assess your students in their chart making skills in Excel along with their problem solving skills.

Part 1 of the quiz students are to pretend they have been given a bag of candy. They are to create a table then a chart with their data.

Part 2 of the quiz you give your students candy and this time they have to record the actual amount and make a table and a chart.

Part 3 of the quiz test basic formula writing.


Common Core - 3.MD.3. Draw a scaled picture graph and a scaled bar graph to represent a data set with several categories. Solve one- and two-step �how many more� and �how many less� problems using information presented in scaled bar graphs. For example, draw a bar graph in which each square in the bar graph might represent 5 pets.