Excel Practical Assignments 50.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Assignment -1
2
3	Use of Formulas Sum, Average, If, Count, Counta, Countif & Sumif
4	Roll No	Student Name	Hindi	English	Math	Physics	Chemistry	Total	Average	Grade
5	1	RAM	20	10	14	18	15	77	15.4	A
6	2	ASHOK	21	12	14	12	18	77	15.4	A
7	3	MANOJ	33	15	7	14	17	86	17.2	A
8	4	RAJESH	15	14	8	16	20	73	14.6	B
9	5	RANJANA	14	17	10	13	18	72	14.4	B
10	6	POOJA	16	8	20	17	15	76	15.2	A
11	7	MAHESH	18	19	3	10	14	64	12.8	B
12	8	ASHUTOSH	19	20	7	14	18	78	15.6	A
13	9	ANIL	22	13	8	12	19	74	14.8	B
14	10	PREM	26	12	10	11	27	86	17.2	A
15
16
17	Q.2 Find Grade Using If Function - If Average Greater >15 then "A" Grade otherwise "B" Grade
18		Name	Grade
19		RAM	#REF!
20		ASHOK	#REF!
21		MANOJ	#REF!
22		RAJESH	#REF!
23		RANJANA	#REF!
24		POOJA	#REF!
25		MAHESH	#REF!
26		ASHUTOSH	#REF!
27		ANIL	#REF!
28		PREM	#REF!
29	Q.3 How Many Student "A" and "B" Grade
30	Ans	A Grade	6		B Grade	4
31	Q.4 Student Ashok and Manoj Total Number and Average
32	Ans	Ashok	77	15.4
33		Manoj	86	17.2
34	Q.5 Count how many Students
35	Ans	10
36	Q.6 How Many Student Hindi & English Subject Number Grater Then > 20 and <15
37	Ans	Hindi	4	1
38		English	0	6
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100