Question: what are the various mathematical functions available in ms excel?
Answer: SUM(): This function is used to adds all the values within a cell range.
Syntax: sum(cell address : cell address)
Example: sum(C1:C3)=15. ... 
Example: sum(4,5,6)=15.
SUMIF(): ... 
Syntax: SUMIF( range,criteria) ... 
AVERAGE(): ... 
COUNT()