Musihenga W 7892 76 75 80 Carren Hassan E 7800 38 48 25 Eunice Soita Naomi W 8490 37 51 29 Wafula W 8184 30 86 75 Phanice Sisa Gentrix E 8082 25 27 20 Waithera E 8033 30 25 25 Scolastica Siboboti W 8047 39 24 25 Sarah Enter the following data in sheet 1. (20 marks) Rename the sheet as Term one results. (1 mark) Find: Totals (2 marks) Average. (2 marks) Use the IF function to remarks as follows: (3 marks) A student whose average is above or equals to 65 gets ‘Excellent.’ An average of 55 or above but less than 65 gets work’ ‘Average An average of less than 55 award average’ (3 marks) ‘Below i) Award positions to students basing the average score (3 marks) ii) On the last rows enter formulas to count students from both classes (2 marks) Sort the students list by class position in ascending order. (2 marks) i) Copy the entire worksheet onto worksheet 2 and rename it group’. (2 marks) ii) Filter the lower group. To display student from class. (1 mark) ‘E’ To display students average score is less than 50 . (1 mark) i) Insert a bar graph to display the following information below: - The three CATS - Names - Title as ONE COMPUTER RESULTS’ (1 mark) ‘TERM ii) Place the legend at the bottom of the graph. (1 mark) iii) Save the chart on a new sheet and name it graphical analysis. (1 mark) j) Print: The filtered lower group (1 mark) The chart (1 mark) Term one results sheet (1 mark)
Musihenga Carren W 7892 76 75 80 Hassan Eunice E 7800 38 48 25 Soita Naomi W 8490 37 51 29 Wafula Phanice W 8184 30 86 75 Sisa Gentrix E 8082 25 27 20 Waithera Scolastica E 8033 30 25 25 Siboboti Sarah W 8047 39 24 25 Enter the following data in sheet 1. (20 marks) Rename the sheet as Term one results. (1 mark) Find: Totals (2 marks) Average. (2 marks) Use the IF function to remarks as follows: (3 marks) A student whose average is above or equals to 65 gets ‘Excellent.’ An average of 55 or above but less than 65 gets ‘Average work’ An average of less than 55 award ‘Below average’ (3 marks) i) Award positions to students basing the average score (3 marks) ii) On the last rows enter formulas to count students from both classes (2 marks) Sort the students list by class position in ascending order. (2 marks) i) Copy the entire worksheet onto worksheet 2 and rename it group’. (2 marks) ii) Filter the lower group. To display student from ‘E’ class. (1 mark) To display students average score is less than 50 . (1 mark) i) Insert a bar graph to display the following information below: - The three CATS - Names - Title as ‘TERM ONE COMPUTER RESULTS’ (1 mark) ii) Place the legend at the bottom of the graph. (1 mark) iii) Save the chart on a new sheet and name it graphical analysis. (1 mark) j) Print: The filtered lower group (1 mark) The chart (1 mark) Term one results sheet (1 mark)
Computer-p2.docx