To complete this task, please download the PracticeExcelSheet_E from here.
Task 1
a.
Calculate the total marks for the class. Enter your answers in column H.
b.
i.
In cell C18, use the appropriate function to enter the most common total mark obtained by the students.
ii.
In cell C19, calculate the number of students who obtained the most common total mark.
c.
In cell C20, use the appropriate function to calculate the number of students in the class.
d.
i.
In cell I3, calculate the percentage mark using the following equation:
Percentage Mark = Student Mark ÷ Maximum Mark x 100.
If your calculation is correct, the percentage mark for Smith Alexander should be 57.7777777777778%.
ii
Use autofill to calculate the percentage marks for all students.
e.
In cell C21, use the appropriate function to enter the average percentage mark.
f.
Count how many tasks are marked as absent. Enter your answer in cell C22.
g.
Count how many tasks were left empty by mistake. Enter your answer in cell C23.
h.
Complete columns K, L and M by rounding off the percentage mark as instructed in the headings of the respective columns.
i.
Rank the total marks in column H, assigning rank 1 to the highest mark and the last rank to the lowest mark. Enter the ranking in column N. In cell N1, enter a heading for this column.
j.
By referring to the marks in column H, use the appropriate function to enter 'Pass' or 'Fail' in column O. Students will pass if they obtain 30 marks or higher. In cell O1, enter a heading for this column.