Microsoft Excel 2010 - I — Question 4
Back to all questionsQuestion 4
Sahil has been given the hard copy of the following worksheet by his teacher.
His teacher has asked him to:
(i) Calculate the total percentage of each student.
(ii) Find the Grade of each student by keeping a simple rule in view, i.e., students scoring below 90% must get B+ while those above this baseline must be given an A+.
(iii) Also find the Maximum marks and calculate the average Marks of both Practical and Theory.
(i) Sahil can calculate the Total Percentage of Veena by using the formula =(C3+D3)/20*100 in cell E3. Then, he can copy the formula in cell range E4 : E7 to calculate the Total Percentage of all students.
(ii) Sahil can calculate the Grade of Veena by using the formula =IF(E3<90, "B+", "A+") in cell F3. Then, he can copy the formula in cell range F4 : F7 to calculate the Grade of all students.
(iii) To find the maximum marks in Practical, Sahil can use the formula =MAX(C3:C7) in cell C10.
To find the maximum marks in Theory, Sahil can use the formula =MAX(D3:D7) in cell D11.
To find the average marks of Practical, he can use the formula =AVERAGE (C3:C7) in cell E10.
To find the average marks of Theory, he can use the formula =AVERAGE (D3:D7) in cell F11.
