Question

Suggest the Excel functions that can be used for carrying out following operations:
1) To calculate total marks of a student of his marks in five subjects are given in five different cells.​

Answer 1

● 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.

Answer 2

by sum method to calculate total marks of a student if his marks in five subjects are given in five different cells