GROUP TWO – ATTEMPT ALL QUESTIONS
1. Define hardware [2]
2. Give one example of hardware [1]
3. A car dealer uses a database to keep details of cars in the stock file as
shown below.
REGNO. MAKE MODEL COLOUR DOORS ENGINE (cc) PRICE ($)
AT 15 APC Renault Laguna Black 5 1600 5800
NX 21 TPQ Opel Corse Green 3 1400 2000
WS 46 ART VW Golf Blue 3 1600 3400
RP 09 NTR VW Golf Red 5 2000 6350
VV 81 KKT Proto Wira White 4 1300 2200
NK 55 ARM VW Golf White 3 1500 4100
(a) State the field_Name that should be used as the key field [1]
(b) Explain the purpose of the key field [2]
(c) The following search condition has been placed in a certain
field. (PRICE ($) < 5000) AND (MODEL = Golf). Write
down the records that match the above search condition using
only REGNO. [2]
(d) Write down a search condition to find cars with an Engine
greater than 1400cc or which have less than 5 doors. [2]
4. An Entertainment company in Lusaka, keeps monthly records
on a spreadsheet of all its organised rock music events. The
information for May 2025 is shown below.
A B C D E F G
1 Event No. of No. seats Seat Total Cost of Profit or
seats sold price money event Loss
($) taken ($) ($)
2 The Bugs 4000 1700 45 76500 85000 Loss
3 Static Rocks 3000 3000 50 150000 100000 Profit
4 The Gold Apes 4000 2150 35 75250 90000 Loss
5 Monophonics 5000 4000 35 140000 125000 Profit
6 Human Senses 4000 4000 60 240000 180000 Profit
7 Ice Patrol 3000 1500 50 75000 80000 Loss
8 The Manual 2000 1650 60 99000 115000 Loss
9
KNU © 2025 Page 1 of 2
(a) What formula is in cell E2 to work out the total money taken
for The Bugs event? [2]
(b) Complete the following statement for cell G4
=IF (E4 > …………………., “Profit”, ………………. [2]
(c) Total cost of Events is to be shown in cell F9. What formula
needs to be placed in F9? ……………… [2]
(d) If the value in C7 was changed to 2000, which cells would be
automatically updated? ………………….. [2]
(e) Describe how to find the breakeven point for any given event
(i.e when cost of event – total money taken).
(f) Give one example of a spreadsheet
5. Give five precise uses of a spreadsheet [5]
The end
KNU © 2025 Page 2 of 2