Important Forumulas
To calculate Average value =average(data range)
To calculate Maximum Value =max(data range)
To calculate minimum Value =min(data range)
To calculate Total =sum(data range)
To calculate Standard deviation =stdev(data range)
To calculate Square root of any number =sqrt(n)
To calculate power of the value =power(X,n)
where X is main value, n is power eg. =power(5,2)=25
To insert current date =today()
To insert current date and time =now()
To calculate the value of sin, cos, tan, log etc
=sin(n)
=cos(n)
=tan(n)
=log(n)
To convert radians to angle =degrees(angle)
To count the values or numbers =count(data range)
End of Ms Excel, I hope you learned something!