6 MS Excel Tutorial #Excel #StatisticalFunction #Average #Count #Counta #countblank #Min #Max

This chapter gives an overview of some very useful statistical functions in Excel.

Statistical Function:-
Average Function returns the average value from a given set of number.
Syntax :=Average(number1,number2,number3,…….)
Example:=Average(10,20,30,40,50,60,70,80,90,100)
=55
Count Function count the number of cells that contains numbers.
Syntax :=Count(number1,number2,number3,……)
Example:=Count(A1:G5)
=5
Counta Function count the number of cells that are not empty.
Syntax :=Counta(valu1,valu2,valu3….)
Example:=Counta(A1:G5)
=5
Countblank Function count the number of empty cells in a specified range of cells.
Syntax :=Countblank(Range)
Example:=Countblank(A1:G5)
=35
Max Function return the largest value in a set of values ignores logical values and text.
Syntax :=Max(number1,number2,number3,…..)
Example:=Max(10,15,20,30,40,50)
=50
Min Function return the smallest number in the set of values ignore logical values and text
Syntax :=Min(number1,number2,number3,….)
Example:=Min(10,15,20,30,40,50)
=10


MS Excel Tutorial Class 6 #Excel #StatisticalFunction #Average #Count #Counta #countblank #Min #Max

JavaScript Full Tutorial Link
https://www.youtube.com/playlist?list=PLHM0mv54H_T7JUehJqRm7XMdbw_7XDhvH

HTML Full Tutorial Link
https://www.youtube.com/playlist?list=PLHM0mv54H_T5p9U4fbdMLWR0MungsxyqN

MS Word Full Tutorial Link
https://www.youtube.com/playlist?list=PLHM0mv54H_T5p9U4fbdMLWR0MungsxyqN

C C++ Full Tutorial Link
https://www.youtube.com/playlist?list=PLHM0mv54H_T7wj_3umqkQpkcy61uQ50jw

DOS Full Tutorial Link
https://www.youtube.com/playlist?list=PLHM0mv54H_T6A5LpFklIse1pgDDfUZ6bg


Shibam Institute of Computer Education (SICE) as you all know is not a new organization. #SICE Computer Institute provides you A Level, O Level, PGDCA, DCA, APGDCA, WEB DESIGNING, AUTO-CAD Courses. A part from that it also provide package courses like DTP, TALLY, PHOTOSHOP, HTML, CSS, JAVASCRIPT, PHP, MYSQL, C, C++, VB.NET, ADO.NET, C#, JAVA. SICE Computer Institute believes in overall development of its students.
So to conclude we may say that you can know it better after one visit to Shibam Institute of Computer Education (SICE). So please do come to the floor for more detail and give us a chance to service.
Located in :
1st Floor, Medical Chowk, Rairangpur,
Odisha, India - 757043
Contact : 9776633572
Email : [email protected]
Website : www.rairangpur.co.in, https://siceindia.business.site/