Dit 0103: Spreadsheets Question Paper
Dit 0103: Spreadsheets
Course:Diploma In Information Technology
Institution: Jomo Kenyatta University Of Agriculture And Technology question papers
Exam Year:2012
STAGE THREE EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY
DIT 0103: SPREADSHEETS
ANSWER ANY THREE QUESTIONS TIME: 2 HOURS
QUESTION ONE
a) List three application areas of electronic spreadsheets (3 marks)
b) List down three spreadsheet applications apart from excel used in the market today (3 marks)
c) In relation to electronic spreadsheets, define the following terms (5 marks)
(I) Formula
(II) chart
(III) Work sheet
(IV) Function
(V) Cell
d) Explain the effect of the following keyboard strokes (5 marks)
(i) CTRL+ HOME
(ii) CTRL+END
(iii) Left arrow Key
(iv) ENTER
(v) Cell
e) Assuming that you wanted to move a worksheet named SALES in workbook1 and workbook 2, what procedure would you carry out? (3 marks)
f) How do you enter data into a cell (1 mark)
QUESTION TWO
a) How do you rename a worksheet (1 mark)
b) In relation to excel, define the following (5 marks)
(I) Legend
(II) Data series
(III) Plot area
(IV) Chat area
(V) Cell range.
c) How do you go about deleting a worksheet (2 marks)
d) Write down procedure for saving worksheets. (2 marks)
e) Name any six operators you know. (3 marks)
f) What will the following be evaluated to? (2 marks)
(i) 7+3/2=
(ii) (7+3)/2=
g) Write down the procedure for using Auto Sum (3 marks)
h) Name any four options found in a Task Pane (2 marks)
QUESTION THREE
a) How do you go about inserting comments in a selected cell? (2 marks)
b) How do you go about removing a comment placed on a cell? (2 marks)
c) Define Freeze pane and give procedure to activate freeze panes (3 marks)
d) List three types of worksheet alignments you know (3 marks)
e) List three types of worksheet alignments you know (3 marks)
f) On a format Dialog Box, list the five components found in it. (5 marks)
g) List any three functions used in excel. (3 marks)
h) In relation to spreadsheet what does Autofill Do? (2 marks)
QUESTION FOUR
a) Explain the functions of the following components. (5 marks)
(i) Name box
(ii) Row heading
(iii) Sheet tab
(iv) Column heading
(v) Formula bar
b) How will you go about inserting a clip art into your spreadsheet? List the steps in merging cells (8marks)
c) What is the difference between SAVE and SAVE AS (2 marks)
QUESTION FIVE
A B C D E
1 MARKS
2 NAMES ENG MATHS KISW TOTAL
3 Dan 40 80 40
4 Abel 60 90 20
5 Lucy 50 60 80
a) In the above worksheet, give both formulas and functions to calculate:
i) Total marks for each individual i.e Dan, Abel and Lucy . (6 marks)
j) Total marks for Eng, Math and Kiswahili (6 marks)
k) Find the average mark for Dan, Abel and Lucy (6 marks)
b) In relation to spreadsheet, what is the importance of print preview feature? (2 marks)
More Question Papers