DIT 0103: SPREADSHEETS Past Paper

W1-2-60-1-6
JOMO KENYATTA UNIVERSITY
OF
AGRICULTURE AND TECHNOLOGY

University Examinations 2012/2013
STAGE I EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY

DIT 0103: SPREADSHEETS

DATE: AUGUST, 2012 TIME: 2 HOURS

INSTRUCTIONS:     Answer Question ONE and Any Other TWO Questions.

Question One – 40 marks

a) Define the following terms:

i) Legend                                                                                                            [2 marks]

ii) Template                                                                                             [2 marks]

iii) Function                                                                                              [2 marks]

 

b) Different between the two referencing styles used in spreadsheets by using examples.

[6 marks]

c) State the steps of creating a named range. [3 marks]

d) State five application areas of spreadsheets. [5 marks]

e) Describe the three components of a spreadsheet. [6 marks]

f) State any five advantages of using electronic spreadsheets. [5 marks]

g) Differentiate between copying and moving data in a worksheet. [4 marks]

h) State aid explain briefly the four datatypes used in spreadsheets. [5 marks]

Question Two – 20 marks

1. a) A worksheet contains the data shown below:

 

Cell	A1	A2	A3	C1	C2	C3	G1	G2
Entry	5	7	10	10	15	15	=sum if(A1:C3”<=10”)

 

i) State the value displayed in G1.                                                         [3 marks]

ii) Write the formular or function that can be used to display the highest vlue/entry from the range in cell G2.

iii.Using the nested if control structure award a grade to the sum at cell G1 whereby:

70 – 100 – A

50 – 70 – B

<49 – C                                                                                               [5 marks]

1. b)

	A	B	C	D	E
1	Name	Score	Award
2	James	50
3	Mary	33
4	Ann	62
5
6	Rate	30
7
8

 

1. c) Differentiate between absolute referencing and relatives referencing style. [4 marks]

Question Three

1. a) A worksheet contains the data as shown below:

	A	B	C	D	E	F	G
1	8		20
2	11		45
3	14		52
4
5

 

i) The formula = COUNTIF (C1: C3, “20”) was entered at G1. Write down the value that was displayed.                                                                    [2 marks]

i) Write down the formula that would be entered at cell B7 to sum the values in column A whose values are greater or equal to 5. [3 marks]

iii.        The formula = $C2 + C$3 is entered in cell C5 and then copied to D10.  Write down the formula as it appears in the destination cell.               [2 marks]

1. b) Use the following information to answer the questions below:

Total                            Remark

350 – 500                    Distinction

300 – 349                    Credit

200 – 299                    Pass

0 – 199                        Fail

Assuming the total mark is in cell D4.  Write a nested if statement that will allocate the

remarks above.                                                                                                [5 marks]

1. i) Differentiate between copying and moving data in a worksheet. [4 marks]
2. ii) State the four datatypes accepted to spreadsheets and briefly explain each. [4 marks]