LAB ASSIGNMENT 2 (EXCEL)


  1. Prepare simple bar diagram form the following data.

Number of Students in ABC College
Year
2005
2006
2007
2008
2009
2010
Number of Student
400
500
700
800
950
1100

  1. Prepare multiple bar diagram form the following data.

Sales of cold drinks

Year
2005
2006
2007
2008
Coke
400
340
390
500
Fanta
500
540
600
650
Sprite
360
440
230
390



  1. Prepare line diagram from the following data.

Indo-Nepal Cricket Tournament
Over
5
10
15
20
Runs by India
40
80
110
175
Runs by Nepal
45
75
115
176

  1. Prepare pie chart form the following data.
Number of students in ABC College
Science
45%
Commerce
32%
Humanities
20%

Post a Comment

0 Comments