Computer Applications
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.
Answer
(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.
Related Questions
Suggest the Excel functions which can be used for the following:
(a) To calculate the average marks obtained by a student in SA1 assuming that his/her marks of individual subjects are given.
(b) To find the highest marks of Hindi in your class, if marks of all students are given.
(c) To calculate the quarterly sales of a sales executive, if the sales data of all months are given.
(d) To find out the minimum quoted tender rates submitted by various companies to the Govt. of India.
Mayur could not complete the assignment given by his teacher which is shown below. Help him to fill the blank cells marked with yellow colour.
The class teacher asked Ravi to observe the following worksheet carefully, and answer the questions based on it:
(i) Identify the nature of formula in the cell E9.
(ii) Copy the formula applied in cell E9 to all the cells from E5 to E11.
(iii) Find the maximum and the minimum value among the cells E5 to E11.
(iv) Calculate the average of both Oral and Written marks.