Question

2. What are the basis mathematic function used in spreadsheet. example with help of example.​

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

Answer 2

Explanation:

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