Question

write the formula to calculate the total marks of students in cell l3

Answer 1

Explanation:  It can be done from two methods

1) By using sum function

• It is used to find the sum of all the numbers which we have in cells.

• It will work only if all the value are written continuously.

Process to calculate total marks of a student of his marks in five subjects

• Select the cell where we find out the total marks

• Type formula that is :- =sum(initial place name : final place name)

• Like 5 subject marks are written in A2 , B2, C2, D2, E2 and we have to find the value in F2

• We will type =sum(A2:E2) in F2

• And you will get desired result as the total marks.

• Note :- instead of typing you can select the cell as well

2) Without function

• We will use simple mathematics to find sum

• It can work for the value written anywhere in the spreadsheet.

• Process to calculate total marks of a student of his marks in five subjects without using function.

• Select the cell where we find out the total marks.

• Like 5 subject marks are written in A2 , B2, C2, D2, E2 and we have to find the value in F2

• Type =A2+B2+C2+D2+E2 in F2

• And you will get desired result as the total marks.