QUESTIONS

Question 1

1. Set your paper to portrait and the margins to 2.4cm(or 0.94’’) all round (2 Marks)
2. Type the document as it is using Times New Roman font face, font size 12 and save it as ‘SDLC’ (30 Marks)
3.  Set the column spacing to 2.4cm (or 0.94’’) (2 Marks)

1. Copy the document above and save it in a new file called ‘SYSTEMS’ (2Marks)
2. Spell check the document and format the heading ' SYSTEMS DEVELOPMENT LIFE CYCLE’ to have the following styles (3 Marks)
   • Centred across the page.
   • Font face: Arial.
   • Font size: 45.
   • Background colour: grey.
3. Change the character spacing of the title to the following settings: (3 Marks)
   • Scale 87%
   • Spacing -Expanded
   • Kerning - 13 points
4. Create a diagonal watermark text called ‘STAREHE BOYS’ CENTRE’ on the SYSTEMS document saved above (2 Marks)
5. Indent the Paragraph beginning with the words "System design" as follows: (2 Marks)
   • Left 0.5cm
   • Right 1.2cm
6. Insert page numbers e.g. 1 of X centered, on the footer with your index number on the right margin (2 Marks)
7. Re Save your work and print the two documents. (2 Marks )

Question 2

The following is a worksheet extracted from business partner’s vendors. They have come together to do a business of selling computer accessories
PARTNER’S VENDORS

Additional information

1. Reserves is 10% of Gross Profit.
2. Net profit = Gross profit – (Expenditure + Reserves)

1. Create a workbook and enter the details as above. Save as Vendor. (20 marks)
2. Keep the title of the workbook to be PARTNER’S VENDORS and format it to be bold, font size 14 and align at 45°. (3 marks)
3. Format the figures in sale column to 2 decimal places. (2 marks)
4. Use appropriate formulae/function to calculate:
   1. Gross profit for each member. (3 marks)
   2. Reserves for each member. (3 marks)
   3. Net profit for each member. (3 marks)
5. Use “IF function” and net profit to analyse the vendors, taking the following remarks: (6 marks)
   1. If net profit > = 500, then “V.good vendor”
   2. If net profit >400, then “Good vendor”.
   3. If net profit < = 300, then “Dormant vendor”.
6. Use names of the vendor and cost to insert line graph, keep the title of the graph to be PRODUCTIVE ANALYSIS, format it and place it in a separate sheet. (5 marks)
7. Print the “PARTNER’S VENDOR” and “PRODUCTIVE ANALYSIS” chart. (4 marks)