cameroon gce intermediate level ict 3 day 2
cameroon gce intermediate level ict 3 day 2
Task II. 30 Marks
Open Task II (Spreadsheet) from the candidate folder and answer the following questions:
i) In cell F4, use a spread sheet formula to calculate the Gross Pay for Romeo Foncham. 4 Marks
( NB: Gross Pay = salary + Rents Allowance)
| ii) Use the auto fill feature in spread sheet to generate the Gross Pay for each teacher. iii) In cell G4, use a spread sheet formula to calculate Tax deductions for Romeo Foncham. (NB: Tax deduction= Salary x 5%) iv) Use the auto fill feature in spread sheet to generate the Tax deductions for each teacher v) Centralize the data in column F, Horizontally and Vertically. vi) Change the font size of the names in columns B to 20pts and wrap the text. vii) Delete roll 1 of the table i.e the title of the table. viii) Save your work and print page 2 only. |
4 Marks 4 Marks |
| 4Marks 4 Marks 4 Marks 4 Marks 2 Marks |
Task III. 30 marks
Open Task III from the candidate folder and answer the following questions::
| i) Sort the irregularities table in ascending order of names. (A-Z) ii) Generate a Tabular Report of the irregularities table and save as Report iii) Save your work and Print page 2 of your Report. |
10 Marks 18 Marks 2 Mark |
