Question

write any 5 formulas which can use in spreadsheet

​

Answer 1

Answer:

Excel formulas and functions

=1+2 // returns 3.

=6/3 // returns 2.

=A1+A2+A3 // returns 9.

=B1+C1+D1 // formula in E1.

=A1 // relative reference =$A$1 // absolute reference.

=D1*$A$1 // formula in E1 =D2*$A$1 // formula in E2 =D3*$A$1 // formula in E3.

=SUM(1,2,3) // returns 6 =SUM(A1:A3) // returns A1+A2+A3.

=AVERAGE(1,2,3) // returns 2.