(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.
(a) Folders are used for storing files in the computer. List the steps for carrying out the following operations; (i) creating a folder on the desktop (ii) giving name on the folder (iii) sending a file from "My Documents" folder into the folder created in 6 (a)(i), (iv) Changing the name of the folder in 6(a)(ii) to "RESULTS".
(b) The table below shows selected fields and Data Types in MS Access. Use it to answer questions 6(b)(i) and 6(b)(ii)
| Field | Data Types |
| Full Name | Text |
| Mat No. | Text |
| Date of Birth | * |
| Fees | * |
| Address | Memo |
(i) What is the appropriate data type for; (I) Date of Birth (II) Fees Fields
(ii) If MS Access is running, describe the procedure to; I. Create a table with the fields as given above using design view II. Set the Mat. No. Field as the primary key. III. Set the Full Name Fieldto a maximum of 50 characters.
One of the characteristic feature of the second generation computer is the presence of
Convert 4\(_{10}\) to a number in base two
Data processed into its useful form is referred to as
