We have created a structure of mark-sheet in spreadsheet. The data such as subjects and marks for respective subjects are entered. Now we will calculate the grand total of marks, by using follwing steps.
As we want to calculate grand total of marks, we have to make summation of marks obtained for all the subjects.
Firstly we will go to cell "J7" where we want our grand total to be displayed
Now write the formula as "=SUM(" then take mouse pointer to cell "D7" and drag the pointer till the cell "I7", by keeping left mouse button pressed. And press "Enter" button.
We should get the final grand total as "424"
[Contributed by administrator on 15. März 2018 14:59:43]
Calculating Grand Total:
We have created a structure of mark-sheet in spreadsheet. The data such as subjects and marks for respective subjects are entered.Now we will calculate the grand total of marks, by using follwing steps.