PDF chapter test TRY NOW
Sathya’s mother has purchased the following items from the market.
Fruit / Vegetable | Rate/Kg | Quantity (Kg) |
Mango | 80 | 2 |
Apple | 270 | 2 |
Orange | 180 | 1.5 |
Potato | 30 | 2 |
Tomato | 14 | 3 |
Make a list of fruits / vegetables and find how much each of them has cost her. And also calculate the total cost.
Steps to calculate the total cost:
- Make the initial worksheet with the given data.

- Type the formula =B2*C2 in Cell E3 to calculate the cost of the Mango (Rate per kg * Quantity).


- Similarly, type all the formulae in the other cells as given.

- To calculate the grand total, Type the formula = D2+ D3+D4+D5 +D6 in Cell D7 and press the enter key to get the result. Or Type the formula =sum (D2:D6) in Cell D7 and press the enter key to get the result.

or


- Save the file with the name ‘Calculate the cost’.

