1
Time: 1:30hrs DATE: JUNE 05, 2018
INSTRUCTIONS
1. This examination paper consists sections, A
2. Attempt ALL questions in Section A
3. Marks distributions have been indicated for each question.
4. The use of mobile phone is strictly prohibited in the examination room
SECTION A
1) Load Ms Excel 2007 and
Create a spreadsheet with the following entries: (25 marks)
B2 = ALLEXANDRIA CAFE
A4 = FOOD ITEM
A5 = PORTION CHIPS
A6 = SADZA & STEW
A7 = RICE & CHICKEN
A8 = HAMBURGER
A9 = SOFT DRINKS
C10 = SUB TOTAL
C11 = SUB TAX @ 15%
C12 = TOTAL COST
AND PERFORM THE FOLLOWING:
i. Make B2 bold, underlined and size 35. (5 marks)
ii. Merge cell A2,B2,C2,D2,E2,F2,G2 and H2,change background color white
(10 marks)
iii. Change Color of ALLEXANDRIA CAFÉ to blue and align Center, Font to 20th
Century Font (5 marks)
iv. Merge Cell A3,B3,C3,D3,E3,F3,G3 and H3,change background color white and
bold, align text center (10 marks)
v. Make all headings, i.e. A4 – D4, bold. (10 marks)
vi. Add new row between Row 4 and Row 3 (10 marks)
vii. Put borders on all entries of the sheet. (10 marks)
viii. Copy all entries and paste in Sheet 2 (10 marks)
ix. Save document with your full name (5 marks)
B4 = QUANTITY
B5 = 3
B6 = 1
B7 = 1
B8 = 2
B9 = 3
C4 = UNIT COST
C5 = 135.00
C6 = 180.00
C7 = 200.00
C8 = 170.50
C9 = 65.00
D4 = COST
A3=Address: P.o Box 116, ilula
fdc,Mazombe,Tanzania