Find : Totals (2mks) Average (2mks) Use the IF function to award remarks as follow (3mks) A student whose average is above or equals 65 is given “Excellent” An average of 55 or above but less than 65 award work” “average An average less than 55 award below average” “work (f) Award position to student basing on the average scored. (3mks) On the last rows formulas to count students from both classes (2mks) (g) Sort the students list by class position in ascending order. (2mks) (h) Copy the entire worksheet onto sheet2 and rename it group” (2mks) “lower Filter group” sheet to display students from class and whose average score is below “Lower “E” 50. (4mks) (i) Draw a bar graph to display the following information (3mks) The three cats Names Title as ONE COMPUTER RESULTS” “TERM Place the legend at the bottom of the graph (1mk) Save the chart on a new sheet and name it graphical analysis (1mk) (j) The filtered group (1mk) The (1mk) (1mk) Term one results
Find : Totals (2mks) Average (2mks) Use the IF function to award remarks as follow (3mks) A student whose average is above or equals 65 is given “Excellent” An average of 55 or above but less than 65 award “average work” An average less than 55 award “work below average” (f) Award position to student basing on the average scored. (3mks) On the last rows formulas to count students from both classes (2mks) (g) Sort the students list by class position in ascending order. (2mks) (h) Copy the entire worksheet onto sheet2 and rename it “lower group” (2mks) Filter “Lower group” sheet to display students from “E” class and whose average score is below 50. (4mks) (i) Draw a bar graph to display the following information (3mks) The three cats Names Title as “TERM ONE COMPUTER RESULTS” Place the legend at the bottom of the graph (1mk) Save the chart on a new sheet and name it graphical analysis (1mk) (j) The filtered group (1mk) The (1mk) Term one results (1mk)
Comp%20pp2%20016.docx