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]
(Visited 145 times, 1 visits today)
Share this:

Written by