Question

1. To find the sum of cells A1 to A6 and to display the answer in A7.
2. To find the average of cells C3 to F3 and to write the answer in G3.
3. To calculate the product of cells A1 to A4 and to display the result in AS​

Answer 1

Explanation:

in A7 enter formula as

=SUM(A1:A6)

Enter following formula in G3

=AVERAGE (C3:F3)

ENTER FOLLOWING FORMULA IN DESIRED CELL

=PRODUCT (A1:A4)

OR =A1*A2**A3*A4