Question

plz tell if u know..​

Answer 1

Answer:

i)=SUM(A1:A3)

ii)=AVERAGE (A1:A3)

iii)=IF(condition)

iv)=COUNT(A1:A3)

Answer 2

Answer:

i) FOR SUM:-

=sum(Range of the cells for calculation)

ii) FOR AVERAGE:-

=average(Range of the cells for calculation)

iii) FOR CHECK CONDITION:-

=If((eg)A2>A5,"_____","__")

iv)FOR COUNT ANY VALUE:-

=count(Range of the cells to be calculated)

I HOPE THIS WILL HELP YOU