Question

all formulas of MS Excel

Answer 1

Hey dear.....

I would help in some formulas used in excel...

Addition....=SUM(from which cell:till which cell)

Multiplication....

=Cell number which is to be multiplied*Cell number from which it has to be multiplied.

If you want to apply the formula for a range of cell then we need not to repeat the formula for each cell.We will only drag the the formula till the cell where the formula is to be used.

To make any cell constant in doing any operation we must use $ sign.

For example C$5$*A5


To find the average...

Average (Cell number from:Cell number to).

To find maximum....

MAX(Number 1:Number 2).
In the same way we can also do minimum for a range of cell.