W1-2-60-1-6
JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY
UNIVERSITY EXAMINATIONS 2012/2013
EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY
DIT 0103: SPREADSHEETS
DATE: AUGUST 2012 TIME: 1.5 HOURS
INSTRUCTIONS: ANSWER QUESTION ONE AND ANY OTHER TWO QUESTIONS
QUESTION ONE
a. What is Microsoft excel. [2 marks]
b. Write down the procedure of moving data is Ms Excel. [2 marks]
c. Explain the meaning of freezing panes. [2 marks]
d. Write down the steps for applying freezing panes. [2 marks]
e. Explain the following terms as used in Ms Excel
i. Home
ii. Cell-pointer
iii. Function
iv. Formula [4 marks]
f. Explain briefly any four general features of Electronic spreadsheets. [4 marks]
g. State any four chart types used in Ms Excel to represent data. [4 marks]
h. Explain any four advantages of using electronic spreadsheets over m annual spreadsheets.
[8 marks]
QUESTION TWO
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 spreadsheet, how do we use Auto-correct operation, highlight the steps followed when Auto-correcting. [4 marks]
d. Differentiate between Save and Save As 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]
QUESTION THREE – 20 MARKS
a. What do you understand by data sort? Then write down the procedure to follow when data sorting. [6 marks]
b. Write down the procedure of copying and pasting data in Ms Excel. [4 marks]
c. How would you perform the following?
i. Insert a worksheet
ii. Rename a worksheet
iii. Delete a worksheet
iv. Insert a row
v. Insert a column [5 marks]
d. Autofilll command is widely used in Ms Excel, briefly explain its purpose. [2 marks]
e. Write down the steps followed when using Autofill command. [3 marks]
QUESTION FOUR-20 MARKS
a. Explain any four advantages of using a spreadsheet program. [8 marks]
b. Mr. Gilbert is a leader at Jomo Kenyatta University and wishes to use Microsoft excel to process the marks of students during their end of semester exam. The table below shows the details entered in the program.
