(a) Use the information in the spreadsheet above to answer questions 5(a)i-v
(i) Write the formula to calculate the total score in Mathematics.
(ii) Write two spreadsheet formulas to calculate Paul’s average score in the four subjects.
(iii) What spreadsheet function can be used to determine the highest score in English.
(iv) Outline the procedure for calculating Vera’s total score in all subjects and give the result in cell H8.
(v) If the minimum pass mark is an average score of 60, write a formula to determine if Etta passed or failed.
(b) Use the diagram below to answer b(i-vii)
(i) What is the name of the application shown in the diagram?
(ii) State one use of the application mentioned in 5 (b) (i)
(iii) Outline the procedure to launch the application from its shortcut on the desktop.
(iv) After launching the application, what is the name of the slide that appears by default?
(v) Identify the part labeled I.
(vi) Write the keyboard shortcut that would also perform the function of the part labeled I.
(vii) Mention three functions that can be performed by the insert button.
Explanation
5(a) (i) =SUM(D2,D3,D4,D5,D6,D7,D8,D9.D10,D11)
OR
=(D2+D3+D4+D5+D6+D7+D8+D9+D10+D11)
OR
=SUM(D2:D11)
OR
=SUM(D11:D2)
(ii) =AVERAGE(D4:G4)
OR
=(D4+E4+F4+G4)/4
OR
=AVERAGE(D4,E4,F4,G4)
OR
=SUM(D4:G4)/4
OR
=SUM(D4,E4,F4,G4)/4
(iii) Max Function OR =MAX(E2:E11)
(iv) Click on cell H8, Type "=SUM(D8:G8)", "Press Enter" OR Click on D8. Hold down the mouse and stop at H8/Highlight D8 to H8, Click on Summation icon on the Menu bar OR Click on G8, Type "=SUM(D8,E8,F8,G8), Press "Enter" OR Click on H8, Type =SUM(D8:G8), Press "Enter".
(v) =IF(111>59,"PASSED", FAILED")
OR
=IF(111>=60,"PASSED", FAILED")
(b) (i) MS PowerPoint
(ii) Presentation
(iii) Double Click on the icon OR Right click on the icon, Select Open
(v) Title slide
(vi) Slide Show View Icon/Slide Show Icon! Slide Show
(vi) F5
(vii) Insert Shapes, Insert Textbox, Insert WordArt, Insert Comment, Insert Video, Insert Symbols, Sound, Table, Clipart, Equation, New Slide, Pictures, Header/Footer, Date & Time, Text Box, Smileys etc.