Information Communication Technology ICT – 20 Spreadsheets | e-Consult
20 Spreadsheets (1 questions)
Login to see all questions.
Click on a question to view the answer
The teacher would set up the spreadsheet as follows:
| Item Name | Price per Item | Total Cost (5) |
| Apple | 1.00 | =B2*5 |
| Banana | 0.50 | =B3*5 |
| Orange | 0.75 | =B4*5 |
Explanation:
- Item Name: The name of the item is entered in column A (e.g., A2, A3, A4).
- Price per Item: The price of each item is entered in column B (e.g., B2, B3, B4).
- Total Cost (5): The total cost for 5 of that item is calculated in column C. The formula in cell C2 is =B2*5, which multiplies the price per item (B2) by 5. This formula is then copied down to the other rows (C3, C4) to calculate the total cost for the other items.