W1-2-60-1-6
JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY
UNIVERSITY EXAMINATIONS 2012/2013
EXAMINATION FOR THE CERTIFICATE IN INFORMATION TECHNOLOGY
DIT 0103: SPREADSHEETS
DATE: AUGUST 2012 TIME: 1 ½ HOURS
INSTRUCTIONS: ANSWER QUESTION ONE AND ANY OTHER TWO QUESTIONS
QUESTION ONE
a. Explain the term spreadsheet. [2 marks]
b. Outline at least four (4) uses of Ms-Excel as a spreadsheet program. [4 marks]
c. With examples, distinguish between
i. Absolute referencing and
ii. Cell referencing [4 marks]
d. Briefly explain the difference between worksheet and workbook. [3 marks]
e. Write down the procedure followed to insert columns between columns. [2marks]
f. Name four types of electronic spreadsheet in use in the market. [5 marks]
g. Explain the meaning of freezing panes. [2marks]
h. Write down the steps for applying freezing panes. [4 marks]
i. Explain the following term as used in Ms Excel;
i. Home
ii. Cell-pointer
iii. Function
iv. Formula [4 marks]
QUESTION TWO
a. What is Microsoft Excel. [2 marks]
b. State four areas where spreadsheets are applicable. [4 marks]
c. Write down the procedure of copying and pasting data in Ms Excel. [4 marks]
d. Define chart graphs in Ms Excel and list down six types of charts used in Ms Excel.
[5 marks]
e. What do you understand by data sort? Then write down the procedures to follow when data sorting. [5 marks]
QUESTION THREE (20 MARKS)
a. State three (3) major toolbars that are commonly used in excel. [3 marks]
b. Outline the steps followed to insert a new sheet tab and colour code it. [6 marks]
c. How can one get help about a feature in excel in case of need? [1 mark]
d. Distinguish between the term cut and copy. [4 marks]
e. State and explain six basic features found in Microsoft Excel. [6 marks]
QUESTION FOUR
a. Write down the steps followed when adjusting column width. [3 marks]
b. What is the difference between relative referencing and Absolute referencing.
[6 marks]
c. In Ms Excel spreadsheets, how do we use Auto-correct operation, highlight the steps followed when auto-correcting. [4 marks]
d. Differentiate between save and save as used in Ms Excel. [2 marks]
e. Write down the procedure for editing data in a worksheet. [3 marks]
f. Write down the procedure followed when deleting a cell. [2 marks]
