Percentage,Sum,Min,Median,Mode,Mod Function in Excel

 

Find Percentage

 

=A2*B2

 

	A	B	C
1	Obtained Marks	Total Marks	Percenatge
2	385	500	77
3	450	500	90
4	486	500	97.2
5	365	500	73

 

Sum Function

 

=SUM(B2:B5)

 

	A	B
1	Fruits	Rs
2	Apple	100
3	Banana	120
4	Pineapple	80
5	Pear	90
6	Max	120

 

Min Function

 

=MIN(B2:B5)

 

	A	B
1	Fruits	Rs
2	Apple	100
3	Banana	120
4	Pineapple	80
5	Pear	90
6	Min	80

 

Median Function

 

=MEDIAN(B2:B5)

 

	A	B
1	Student Name	Remarks
2	Teena	85
3	Mani	52
4	Pradeep	62
5	Kapil	74
6	Median	68

 

Mode Function

 

=MODE(B2:B5)

 

	A	B
1	Student Name	Remarks
2	Teena	85
3	Mani	52
4	Pradeep	85
5	Kapil	74
6	Mode	85

 

Mod Function

 

=MOD(A2,B2)

 

	A	B	C
1	Number	Divide By	Remender
2	10	3	1
3	14	4	2
4	-3	2	1
5	1000	7	6