Now to calculate percentage of total write this Percentage formula in cell C4 and drag it down. So we say what part is what percent of total and should be calculated as. 100 400 and 600.
And then it will find the Total marks its Average and percentage.
First find the total. To calculate this we first sum up the two marks and then apply the equation as usual. Next it finds the Total and Percentage of those Five Subjects. And therefore our answer will be 46.