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.
1.jpg 
  • Type the formula =B2*C2 in Cell E3 to calculate the cost of the Mango (Rate per kg * Quantity).
2.jpg
 
2a.jpg
  • Similarly, type all the formulae in the other cells as given.
3.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
 
or
 
4a.jpg
 
4b.jpg
  • Save the file with the name ‘Calculate the cost’.
5.jpg
 
5a.jpg