Question

COMPUTTER STUDIES Use Microsoft Excel spreadshoet to create the given table: (start your data entry in Cell AI) 10. 1 mark ITITIT Name AN Yusuf Uche Lilian Inglish 51 Mathematics 63 62 Computer studies 49 53 Average 62 74 Ajayi Femi Bako James Davis Joy 60 80 55 92 68 [b] Calculate the average score for each student Write the formula to find the maximum score for Ajayi Femi What is the cell reference of Uche Lilian's Computer score? Write a formula that would display the number of values entered for Mathematics scores. i. i. iv. Plot a column chart using the table Print and submit hard copy of your work V. vi, 4 mi FIC TECHNOLOGY Draw a line S

Answer 1

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! E 2 Α 1 Name Ali Yusuf 3 Uche Lilian Ajayi Femi Bako James 6 Davis Joy 7 8 Answer bii 9 10 Answer b iii 11 12 Answer b iv B English 51.00 62.00 74.00 48.00 65.00 Mathematics Computer Studies 63.00 49.00 62.00 53.00 60.00 80.00 55.00 92.00 68.00 63.00 G H Average Formula for average This is Answer to bi 54.33 AVERAGE(B2:D2) 59.00 AVERAGE(B3:D3) 71.33 AVERAGE(B4:04) 65.00 AVERAGE(B5:05) 65.33 AVERAGE(B6:06) Formula for maximum score of Ajayi Femi= MAX(B4:04) Cell reference for Uche Lilian Computer Score= D3 Formula for number of values entered for mathematics score= COUNT(C2:06)