Question 1 Report
TEST OF PRACTICAL KNOWLEDGE QUESTION
(a) Use the information in the spreadsheet to answer questions s(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 fir 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 short cut on the desktop.
(iv) After launching the application, what is the name of the slide taht appears by default?
(v) Identify the oart labeled I.
(vi) Write the keyboard shortcut that would also perform the function labeled I.
(vii) Mention three functions that can be performed by the insert button.