Pivot table:
-Pivot table
make it easy to arrange and summarize complicated data and drill down the
details.
Process: -
ü Select your
data range
ü Click on
insert tab
ü Click on
pivot table
ü Define the
condition as you need
Chart: -Chart is
graphical representation of sheet data. Excel can build a chart automatically
based on existing data. There are available many types of charts like column,
bar, pie, line etc.
Column
chart: -This
chart is used to show the comparison between various data series. The data
items of data series is represented on chart through vertical strip.
ROLL
|
NAME
|
PHY
|
CHE
|
MATH
|
TOTAL
|
1
|
RAJ
|
78
|
87
|
67
|
232
|
2
|
SOHAN
|
45
|
87
|
78
|
210
|
3
|
JILANI
|
67
|
98
|
98
|
263
|
4
|
AMIT
|
89
|
76
|
45
|
210
|
5
|
IRSHAD
|
67
|
56
|
67
|
190
|

Process: -
ü Select your
data range
ü Click on
inset tab
ü Click on
chart
ü Select any
chart style
Bar chart: -This chart
is used to show the comparison between various data series. The data items of
data series is represented on chart through horizontal strip.
ROLL
|
NAME
|
PHY
|
CHE
|
MATH
|
TOTAL
|
1
|
RAJ
|
78
|
87
|
67
|
232
|
2
|
SOHAN
|
45
|
87
|
78
|
210
|
3
|
JILANI
|
67
|
98
|
98
|
263
|
4
|
AMIT
|
89
|
76
|
45
|
210
|
5
|
IRSHAD
|
67
|
56
|
67
|
190
|
