Sunday, January 27, 2013

IT Apps - Exercise 8


1        The following survey of favourite ice cream flavours will be used for the example.  
Chocolate - 6 students
Strawberry - 5 students
Vanilla - 4 students
Rocky Road - 3 students
Peanut Butter Ripple - 2 students
Butter Pecan - 2 students
Neapolitan - 1 student
Black Cherry - 1 student

a)      Enter “Ice Cream Survey” in cell A1
b)      Enter “Flavour” in cell A2.
c)       Enter “Number” in cell B2
d)      Enter the flavour names in cells A3 to A10.
e)      Enter the corresponding number of students in cells B3 to B10
f)       Enter “Total” in cell A11.

2        Now you need to find the total number of the students.
3        Create a pie chart with the title chart “ICE-CREAM SURVEY



No comments:

Post a Comment