cameroon gce intermediate level ict 3 day 2

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

PDF is loading please wait...


Leave a comment

Your email address will not be published. Required fields are marked *

Download our application
kawlo
sponsors Ads