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’.
Register for free to see more content