UNIVERSITY EXAMINATIONS: 2019/2020
EXAMINATION FOR THE DIPLOMA IN INFORMATION
TECHNOLOGY/ DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DCU 201: COMPUTER APPLICATION SOFTWARE
DATE: MAY, 2020 TIME: 6 HOURS
INSTRUCTIONS: Answer ALL Questions
SECTION B (20 MARKS)
QUESTION ONE
The chairperson of a Spot link distributors intends to send letters to committee members
informing them of his intended visit to their sites. He has requested you to use mail merge
facility to prepare the letters.
a) Open a word processing program and create a data source with the following
information and save it as CONTACT DETAILS in the folder named MOODLE
WORD EXAM. (6 Marks)
b) Type the letters as it appears below in a new document and save it main document in
the MOODLE WORD EXAM FOLDER (6 Marks)
c) Merge the data source created in (a) above to the main document created in (b) above.
Save the document as LETTER in the MOODLE EXAM Folder. (8 Marks)
SECTION C: (20 MARKS)
QUESTION ONE
a) Open Microsoft Spreadsheet and key in the data in sheet 1 as it appears. Save the
workbook as KCA limited in the folder called MOODLE EXCEL QUIZ FOLDER
(2 Marks)
i) Insert a row above ROW 1 (1 Marks)
ii) In the row you have created, merge A1:I 1 (2 Marks)
iii) Insert the title KCA STATIONERY LIMITED and center it. (1 Marks)
iv) Format the tittle to :font style; comic sans Ms and Font Size: 14 (2 Marks)
b) Using a function and cell references only, calculate the total cost for each item
(2 Marks)
i) Use font color yellow blue for total cost column (2 Marks)
c) Using a formula and cell references only, calculate the total sales for each of the
quantities sold. (2 Marks)
i) Apply Kshs currency format to all the cells showing amounts (2 Marks)
d) Insert an embedded 3D clustered column chart showing total sales and total cost.
(2 Marks)
i) Copy the chart created to a new sheet and name it DAILY CHART (2 Marks)
