Paper 1 structured question: Manipulate data
Paper 1Theory2 marks
Description
Sales Data Table
The table records sales transactions including the product name, quantity sold, and price per unit.
| Product | Quantity Sold | Price per Unit |
|---|---|---|
| Pen | 100 | 0.50 |
| Notebook | 50 | 1.20 |
| Eraser | 75 | 0.30 |
| Marker | 40 | 1.00 |
- a[2]
Describe How would you create a calculated field to find the total sales for each product?