Get premium membership and access revision papers, questions with answers as well as video lessons.

Cit 0103 : Spread Sheets Question Paper

Cit 0103 : Spread Sheets

Course:Certificate In Information Technology

Institution: Jomo Kenyatta University Of Agriculture And Technology question papers

Exam Year:2012

JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY
University Examinations 2012/2013
EXAMINATION FOR A CERTIFICATE IN INFORMATION TECHNOLOGY

CIT 0103 : SPREAD SHEETS

DATE: DECEMBER 2012 TIME: 2 HOURS

INSTRUCTIONS: ANSWER QUESTION ONE AND ANY OTHER TWO QUESTIONS
TOTAL MARKS – 70 MARKS

QUESTION ONE

(a) Define spreadsheet [2 marks]

(b) Write down four spreadsheets applications [4 marks]

(c) Explain five features found in MS excel screen [5 marks]

(d) Explain the following terms as used in Ms Excel
(i)A cell
(ii)Range
(iii)Worksheet
(iv)Workbook [4 marks]

(e) With example, distinguish between
(ii)Absolute referencing

(f) In Ms-excel, spreadsheet has to do we Auto-correct operation, highlight the steps followed when Auto-correcting [4 marks]

(g) Identify three formatting features applied on the worksheet [3 marks]

(h) Explain the following terms as used in Ms Excel [4 marks]
(i)Home
(ii)Cell pointer
(iii)Function
(iv)Formula

QUESTION TWO

(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 M excel [4 marks]
(c) How would you perform the following [5 marks]
(i)insert a worksheet
(ii)rename a worksheet
(iii)delete a worksheet
(iv)insert a row
(v)insert a column
(d) Auto fill command is widely used in Ms excel. Briefly explain its purpose [2 marks]
(e) Write down the steps followed when using auto fill command [3 marks]

QUESTION THREE [20 MARKS]

(a) There arise need to insert new column in your worksheet to accommodate missing information outline procedure for doing it [4 marks]
(b) Define Ms excel [2 marks]
(c) Identify three formatting features applied on the worksheet [3 marks]
(d) Explain the function of the following icons [4 marks]

(e) State at least 6 types of charts used in Ms excel for analysis and define what a chart is
[7 marks]

QUESTION FOUR [20 MARKS]

(a) Explain the meaning of freezing pane [2 marks]
(b) Write down steps for applying freezing pane [3 marks]
(c) Write down the procedure for editing data in a worksheet [3 marks]
(d) Write down the steps for followed when deleting a cell [3 marks]
(e) Write down steps for adjusting column width [3 marks]
(f) Write down the steps to insert a new sheet tab and color code it [6 marks]

QUESTION FIVE

(a) State four areas where spreadsheet are applicable [4 marks]
(b) State 3 major tool bars that are commonly used in Ms Excel [3 marks]
(c) Explain the use of AUTO FILL command in Ms excel [2 marks]
(d) Write down the steps followed to rename a worksheet [3 marks]
(e) Name four types of electronic spreadsheets in use today [4 marks]
(f) Highlight the instances where worksheet is useful [4 marks]

Cit 0103 : Spread Sheets Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams