1
SPREADSHEETS.
KCSE 2010 Q4 & Q18c (i)
4.Distinguish between a formula and a function as used in spreadsheets. [2 marks]
18 (c) Distinguish between each of the following:
(i) Axis labels and data labels; [2 marks]
KCSE 2011 Q18 (d)
Figure 1 shows a section of a worksheet containing information on household items. Use it to answer the
questions that follow.
Figure 1
(i) Write a formula to calculate the total cost of rice. [1 mark]
(ii) The prices of all items increased by 10% and the value 10% is placed in cell B8. Using cell addresses
with absolute referencing only, write a formula to calculate the new unit price of salt. [2 marks]
(iii) Write a function to display the number of cells in which the cost per unit is equal to 110. [2 marks]
(iv) Write a function to display the least total cost for all items. [2 marks]
KCSE 2012 Q8
Differentiate between relative cell referencing and absolute cell referencing. [2 marks]
KCSE 2013 Q6
A retailer uses a spreadsheet program to calculate profits. Figure 1 shows the spreadsheet.
(a) Which row contains labels only? [1 mark]
(b) Write the formula that has been entered in cell F2. [2 marks]
Jackson Mutava @ Alliance High School Kenya.
2
KCSE 2014 Q 19(c)
The following is an extract of a spreadsheet created to manage sales. Use it to answer the questions that
follow.
A B C D
1 ITEM NAME UNIT PRICE UNITS SOLD
2 Bed 12,300 2
3 Wardrobe 16,000 4
4 Blanket 5,000 4
5 Mattress 7,000 5
6 Table 10,000 3
(i) Write a formula that will compute the number of items whose unit price is more than 10,000.
[3 marks]
(ii) If the formula =$B2*C$2 was placed in cell D2, state the output if it was copied to D3. [2 marks]
KCSE 2015 Q20(c)
Figure 2 is an extract of a spreadsheet showing what the students had targeted to score and the actual
score in a computer remedial class.
A B C D E
TARGET ACTUAL PERFORMANCE REMARK
NAME
1 SCORE SCORE FACTOR S
2 Abdi 40 45
3 Alex 30 65
4 Ben 50 60
5 Betty 30 20
6 Ben 45 45
7 Sheila 70 60
Figure 2
A performance factor is obtained by subtracting the target score from actual score and dividing the
difference by the target score.
Write the formula that uses cell references only that would be entered in cell:
(i) D2 to compute the performance factor. [2 marks]
(ii)E2 To display the statement “more remedials” if the performance factor is less than zero, “exempted”
if the factor is greater than zero and “optional” remedials if otherwise. [4 marks]
(iii) D8 to display the best performance factor. [1 mark]
KCSE 2016 Q13
Jackson Mutava @ Alliance High School Kenya.
3
Distinguish between a formula and a function as used in spreadsheets. [2 marks]
KCSE 2017 Q11
State the spreadsheet function that can be used to obtain each of the following values in a worksheet:
(a) Number of cells with values in column. [1 mark]
(b) Mean of values in a range of cells. [1 mark]
KCSE 2018 Q12 &Q14
12.Explain the function of protect sheet feature in a spreadsheet program. [2 marks]
14.In a spreadsheet, the formula =IF (A1>10, A1*77, A1*50) is entered in cell. Interpret the results.
[3 marks]
KCSE 2019 Q18 (c)
Interpret each of the following spreadsheet formula:
(i) =Countif(D2:D9,”>”&B4) [2 marks]
(ii) =Sumif(B3:B11,”4M”D3:D11) [2 marks]
KCSE 2020 Q18 (c)
A teacher entered test scores in a spreadsheet in the cells range C4 to C38. State the formula that should
be used to:
(i) Compute each of the following scores:
I. Mean of the scores. [1 mark]
II. Number of scores whose values exceed 50. [2 marks]
(ii) Display the text “PASS” if the score is greater than or equal to 30 and the text “FAIL” if otherwise.
[3marks]
KCSE 2021 Q5 & 19(a)
5.The following data is to be entered in spreadsheet cells:
(a) 0922 111 000
(b) 31/01/2022
State the cell format, other than the text format, that can be applied to the respective data cells in order to
appear as it is. [2 marks]
19(a) Explain the purpose of each of the following features of spreadsheet chart:
(i) Legend [2 marks]
(ii) Data series [2 marks]
(iii) Data marker [2 marks]
Jackson Mutava @ Alliance High School Kenya.
4
KCSE 2022 Q3 & Q5
3. Explain the tern label as used in spreadsheet program. [2 marks]
5. Figure 1 shows an extract from a spreadsheet program used by a shopkeeper to compute the total cost
of items in stock.
A B C D
1 ITEM UNITS UNIT PRICE TOTAL COST
2 Cooking fat 3 250
3 Sugar 4 100
Figure 1
Write a function that would be used to obtain the total cost of cooking fat. [2 marks]
KCSE 2023 Q20 (a)
(i) State the meaning of each of the following terms used in spreadsheet:
I. Cell [1 mark]
II. Chart [1 mark]
(ii) State two differences between a function and a formula as used in spreadsheets. [2 marks]
KCSE 2024 Q9
Write an example for each of the following cell reference methods in spreadsheets. [3 marks]
(a) mixed reference;
(b) relative reference;
(c) absolute reference
Jackson Mutava @ Alliance High School Kenya.
