Question

Write down the three different formulae of ms excel

Answer 1

Formulae-

1)SUM. Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5) ...

2)COUNT. Formula: =COUNT(A1:A10) ...

3)COUNTA. Formula: =COUNTA(A1:A10)

4)LEN. Formula: =LEN(A1) ...

Answer 2

=sum(x1:x3)

=max(x1:x3)

=min(x1:x3)

.........................................