Question

Practice any 50 commonly used

Functions in MS Excel. List out the

Practiced Functions and describe their

utility in MS Excel.​

Answer 1

Answer:

Here is a list of most frequently used mathematical formulas in excel.

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()