GROUP 4

SPREAD SHEET

1999

a) Work sheet cell are referetied using the column letter and row number eg d2 is cell in column D row 2

Use the semple work provided to answer questions below.

1 Month Jan Feb Mar April Total

2 Fees 460 460 460 460
3 Food 300 350 305 270
4 Electricity 100 100 100 100
5 Fuel 150 150 150 130
6 Transport 380 270 150 300
7 Total

b) Write down the date type that is stored in cell C5 (1mks)

c) What Cell contains the data item representing transport for the month of February (1mks)

c) Write down the formula that may be used to compute the total in cell F6 (1mks)

2000

Andrew, Jane, David, and zabian had tea , sausage and bananas for breakfast they took one sausage
three sausage and one sausage respectly in condition they each look a cup of tea and two banana. Tea,
sausage and banana cost ksh .10,15and 5 respectivly by naming columns A,B,C…..and raw 1,2,3…..

Construct a worksheet showing the above information (7marks)

d) State the expression you would use to obtain:

i)Total expenditure by David (4marks)

ii) Total number of sausage taken (2marks)

iii) The cost of the cheapest item (2marks)

 2001

The first column in the table below contains the formulae as they would appear when copied to cell M 20
of the same spread sheet.
Formula in F10 formular in M20.

=D10*E10

=A$25

=$D$13

2002

The formula =K20+P$18 was typed in cell L21 and then copied to the cell M 24of a spreadsheet . Write
the formula as it appears in cell M24 . (2mrks).

2003

Distiguish btwn labels and formulae with respect to spreadsheet (2mks)

b) Consider entries made in die cell below

Cell B2 B3 C10 C11 C13

Entry 200 100 B2 B3 =C10+C11

State the value displayed in cell C 13. (2mks)

Explain why value such as 611233444555 may be displayed as ##### when typed in a cell of
spreadsheet.(2mks)

How can the problem in (b) (i) above be corrected ? (2mks)

2004

A student presented a budet in the form of a worksheet as follows.

1 A B C
1 Item Amount
2 Fare 200
3 Stationary 50
4 Bread 300
5 Miscellaneous 150
6 Total

The students inteds to have spent half the amount by mid -term .

a) Given that the value 0.5 is typed in cell B9, write the shortest formula that would be typed in cell C2
and then copied down the column obtain half the values in column B. (1mark)

b) write two different formulae thet can be typed to obtain the total in cell B6 and then copied in cell C6.
(2marks)

2005

4) The cell K3 to K10 of a work sheet contain remarks of students performance such as very god, good,
fair and fair depending on the average mark .Write a formula that can be used to count all students
who have remark “very good” (3marks)

16) the following information shows income and expenditure for “Bebayore” matatu for five days . The
income from Monday to Friday was Kshs. 4000,9000,10,000,15000 and 12000 respectively while the for
the same .period was ksh 2000, 3000, 7000 ,5000 and 6000 respectively.

1) Draw a spreed sheet that would contern the imformation indicate the rows as 1,2,3…. And columns as
A,B,C…..(4marks)

ii) state the expression that would be used to obtain:

i) Monday profit (2marks)

ii) Total income (2marks)
iii) Hioghest exependiture (2marks)
Distiguish btwn the following scts of terms as uses in spreadsheet

i) worksheet and work book (2marks)

ii)Total income (2marks)

iii)Highest expenditure (2marks)

2006

18) Distunguish btwn the following sects of terms as used in spreadsheets

i) work sheet and workbook (2marks)

ii)Filtering and sorting (2marks)

b) state one way in which a user may reverse the last action taken in a spread sheet package (1mark)

c) The following is a sample of a pay foll. The work sheet row and column headings are marked 1,2,3……
and A,B,C….. Respectively .

A B C D E F G H
Name Hours PAY PER BASIC PAY ALLOW GROSS TAX NET PAY
worked HOUR ANCE PAY DEDUCTION
KORIR 12 1500
ATIENO 28 650
MUTISO 26 450
ASHA 30 900
MAINA 18 350
WANJIKU 22.5 500
WANYAMA 24.5 250
OLESANE 17 180
MOSETI 33 700
TOTAL
Use the following expression to answer question that follow

 Basic pay=hours worked *pay per hour

 Allowances are allocated at 10% of basic pay
 Gross pay=basic pay +allowances
 Tax deductions are calculated at 20% of gross pay
 Net pay=gross pay-tax deductions

Write formulae using cell refrences for the following cells.

i) D2 (1mark)
ii) C4 (1mark)
iii) F10 (1mark)
iv) G7 (1mark)
v) H5 (1mark)
 2007

Explain data series axis and legend as used in spreadsheet charts(3mks)

2009

A computer accessories vendor needs to order supplies a spreadsheet is used to calculate the order part
of which is shown below .

1 Item Price per unit Number ordered cost (ksh)

2 56k model 8,565.00 60
3 128 MB Ram 4,950.00 40
4 Pentium iv 13,525.00 55
processor
5 TOTAL
(a) Write formula that can be used in:

D2 (1 mark)

D2 (1mark)

(b) If a value added tax (VAT) 0716% was charged on each item and the number ordered was
decreased by 10%. Write new formula that can be used in D2. (2marks)

2011

(18 a) Distinguish between each of the following

(i). Axis lables and data lables (2marks)

(ii). Cropping and sizing (2marks)
(c) Figure 1 Shows a section of a worksheet containing information on household items. Use it to
answer the questions that follows:

1 ITEM DESCRIPTION No of units Cost per unit

2 Wheat flour 12 110
3 Rice 6 145
4 Sugar 7 140
5 Salt 2 20
(i). Write a formula to calculate the total Cost of rice
(ii). The prices of all items increased by 10% and the value 10% is placed in cell B8. Using cell
address with absolute referencing only. Write a formula to calculate the new unit price of
salt (2marks)
(iii). Write a function to display the number of cells in which the cost per unit is equal to 110.
(2marks)
 2015

(20 a)Figure below show extract spreadsheet showing. What the students had targeted to score and
the actual score in a computer remedial class.

1 NAME TARGET ACTUAL PERFORMANCE REMARK

SCORE SCORE FACTOR
2 Abdi 40 45
3 Alex 30 65
4 Ben 50 60
5 Betty 30 20
6 Bena 45 45
7 Sheila 70 60
A performance Factor is obtained by substracting the target score from the actual score and dividing
the difference by the target score.

Write a formula that uses cell references only that would be entered in cell

(i). D2 to compute the performance factor. (2marks)

(ii). E2 to display the statement “More” remedials if the performance factor is less than Zero and
optional remodials if otherwise. (4 marks)

(iii). D8 to display the best performance factor.

2016

I4: In a spreadsheet the formula =if (A1>10, A1*77, AI*5O) is entered in a cell. Interpret the results.
(3 marks)
2019

C) interpret each of the following spreadsheet formular:

i) =count if (d2=d9,:”>”88B) (2marks)
ii) =Sum If (B3:B11,”4M”,D3:D11) (2marks)

2020

A teacher entrect test score in a spread sheet in the cell range C4toC38. State the following scores .

i) Mean of the scores (1marks)

ii) Number of scores whose value exceed 50 (2marks)

2022

Figure shows the an extract from a spread sheet program used by a shopkeeper 10 computer the total
cost items in in stocks

A B C D
1 ITEM UNITS UNITS PRICE TOTAL COST
2 Cooking fat 250
3 Sugar 2 100
Write a functions that would be use it to obtain the total cost of cooking fat(2marks)

2021

Explain that purpose of each of the following features of a spreadsheet chart (6mark)

i) Legend
ii) Data series
iii) Data marker

2013

1 Items Cost price Selling price Profit Item sold Total profit
peritem
2 Item1 305 350 45 32 1440
3 Item2 100 120 20 45 900
4 Item3 200 220 20 32 640
5 Item4 107 130 23 89 2047

a) Which raw contain lables only? (1mark)

b) Write the formula that has been entered in cell F7 (2marks)

2017

11. state the spreadsheet function that be used to obtain each of the following values in a worksheet

a. number of the cells with values in a column

b. mean of value in a range of cells