IGCSE Computer Science Paper-1: Specimen Questions with Answers 164 - 164 of 164
Question 164
Write in Short
Short Answer▾A shop uses a spreadsheet to keep a record of daily sales in its electrical department. Calculate the stock value for Camera, Iron and Fan?
| SL. NO | ITEM | NO. IN STOCK | NO. SOLD | PRICE ($) | STOCK VALUE |
| 1 | Camera | 32 | 3 | 150.00 | |
| 2 | Iron | 80 | 14 | 82.50 | |
| 3 | Fan | 144 | 15 | 37.15 | |
| 4 | Kettle | 60 | 80 | 190 | |
| 5 | Keyboard | 55 | 26 | 145 |
Explanation
The stock value ($) of each item sold is given by
- Stock Value for Camera
- Stock Value for Iron
- Stock Value for Fan