Word and Excel
Word and Excel
Word and Excel
a) Type the following letter as it appears in a word processor. Use the mail merge feature to produce
copies of the same letter to the persons whose details are given below:
Yours truly
Head teacher.
Required:
i) Save main document as main doc (1 mark)
ii) Save data source as ‘data source’ (1 mark)
iii) Change addresses and reference font size to 14 points. (1½ marks)
iv) Merge the letter into main document so as to produce copies for all the candidates and
save it as results 2009. (6 marks)
v) Print the letter, main doc, data source, results 2009. (3 marks)
b) Type the following text in a word processing software. (22 marks)
Required:
a) Align the title to the centre and underline it. (1 mark)
b) Add border to the title. (2 marks)
c) Replace all the roman numbers with bullets. (1 mark)
d) i) Insert the footer ‘computer assessment test’. (2 marks)
ii) Insert the header ‘your name and index number’. (2 marks)
e) Set the spacing to exactly 1.5 (3 marks)
f) Insert word art ‘COMPUTER’ and set it to appear behind the text. (2 marks)
g) Search for words ‘computer’ and replace all with ‘pc’ (2 marks)
h) Move paragraph with heading ‘How a computer operates’ to the end of the document. (2 marks)
i) Set the font style of the document to Aerial black. (1 mark)
j) Save your work as ‘computer literacy’ (1 mark)
k) Print your document. (1 mark)
2.
a) Create a new workbook and name it as form 4 computer exams.
NAME CLASS ADM NO CAT1 CAT2 CAT3 TOTAL AVERAGE CLASS POSITION REMARKS
Benard K E 8092 86 59 75
Mitei E E 7800 38 48 25
Mark J W 8490 37 51 29
James W E 8082 25 27 20
Leonard B W 8047 39 24 25