Can you help me with this excel task: (photo attached)
1) show the total student population of the left
2) sort the data according to the cohorts
3) sort the data in each cohorts in alphabetical order of surnames
4) show total number in each cohort
5) calculate the total score for each individual. The total score is out of 500 marks.
6) for each general subject score find its;
a) average score
b) maximum score
c) minimum score
d) count the number of students who missed any task in each subjects.
7) calculate the percentage score for all students
8) allocate grades according to the percentage break up shown below.
>85 A, >70 B, >55 C, >45 D, E
9) rank the students according to their percentages.
10) identify which student have PASS or FAIL the general subjects based on the following criteria: percentage more than or equal to 55% had passed.
11) count the number of A’s, B’s, C’s, D’s & E’s
12) show all the formula sheet