![](http://uploads.cdn.yaclass.in/upload/pumpa/img_4.png)
PUMPA - SMART LEARNING
எங்கள் ஆசிரியர்களுடன் 1-ஆன்-1 ஆலோசனை நேரத்தைப் பெறுங்கள். டாப்பர் ஆவதற்கு நாங்கள் பயிற்சி அளிப்போம்
Book Free DemoSathya’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.
![1.jpg](https://resources.cdn.yaclass.in/889b052e-e1d8-48dc-abad-b9264fdcc071/1w300.jpg)
- Type the formula \(=B2*C2\) in Cell E3 to calculate the cost of the Mango (\(Rate\) \(per\) \(kg\) \(*\) \(Quantity\)).
![2.jpg](https://resources.cdn.yaclass.in/d9eeb0eb-20fa-4002-a2ee-6f155e512de3/2w300.jpg)
![2a.jpg](https://resources.cdn.yaclass.in/9355c5c8-1d71-4a6f-b7a9-c91aaa6de51f/2aw300.jpg)
- Similarly, type all the formulae in the other cells as given.
![3.jpg](https://resources.cdn.yaclass.in/6131a94b-8073-499d-b02e-c4e80af56460/3w300.jpg)
- 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.
![4.jpg](https://resources.cdn.yaclass.in/1611c08e-be80-476c-ab28-0dcb271957af/4w300.jpg)
or
![4a.jpg](https://resources.cdn.yaclass.in/b045d00b-1081-4806-9804-5bf0ec860cb3/4aw300.jpg)
![4b.jpg](https://resources.cdn.yaclass.in/2b44c80a-f11d-4be0-bc26-dd5857b0284d/4bw300.jpg)
- Save the file with the name ‘Calculate the cost’.
![5.jpg](https://resources.cdn.yaclass.in/3bad7a8a-d6c0-41cc-9a1f-32feef8b08a7/5w300.jpg)
![5a.jpg](https://resources.cdn.yaclass.in/83dbdc25-4f91-4190-afd6-46922cae7ddf/5aw300.jpg)