If several languages coalesce the grammar
3 min ago
It will seem like simplified English.
1 hours ago
As a skeptical Cambridge friend of mine occidental.
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 needChart: -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
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
210
3
JILANI
98
263
4
AMIT
89
76
5
IRSHAD
56
190
Process: - ü Select your data range ü Click on inset tab ü Click on chart ü Select any chart styleBar 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
ü 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.
Pie Chart: -This chart is used to show the percentage of sum data series. The data items of data series are represented by percentage wise.
COUNTRY NAME POPULATION INDIA 20% PAKISTAN 10% JAPAN 20% CHINA 40% NEPAL 10%
COUNTRY NAME
POPULATION
INDIA
20%
PAKISTAN
10%
JAPAN
CHINA
40%
NEPAL
Line chart: -This chart is used to show the data series through the line whose value change time to time.
OVER 10 20 30 40 50 INDIA 70 140 210 300 360 PAKISTAN 70 140 220 270 320
OVER
10
20
30
40
50
70
140
300
360
220
270
320