Question

a. Define the cell addresses for Sum, Product, Total and average.
b. How many columns are defined in the above spreadsheet?
c. How many rows are defined in the above spreadsheet?
d. Write the formula in the cells B10, C10 and D10 to calculate the total marks in subjects
hindi, sci and IT.
e. Write the formula in the cells B11, C11 and D12 to calculate the average marks in subjects
hindi, sci and IT.
f. Write the formula in the cells E 3 to E8 to calculate the sum in all the subjects for all the
students given in the spreadsheet.
g. Write the formula in the cells F 3 to F8 to calculate the Product in all the subjects for all
the students given in the spreadsheet.
h. Specify the alignment for the text total and average.
i. Name the reference for C3, $F10.
j. Specify the alignment for the text Hardik

Answer 1

Answer:

i don't know if you are good the answer is corret