MYP4

Working with tables



Kontakt: palkovaj@yahoo.com
Dátum poslednej aktualizácie ...6.novembra 2007

Valid HTML 4.0!

exercise image

Rewrite and format the above shown table into your table processor. Your task will be to search in your memory for last years knowledge and apply it in solving the calculations and exercises that go with this table. Follow the instructions:

  1. calculate the sum of all pieces we bought; use function SUM
  2. calculate the average price for items we bought, without GDP
  3. calculate the price per item with GDP; use the prepared cell B17; write the calculation only for the first row and then copy it into the rest of the rows
  4. calculate the cost for each item, depencing on how many pieces we bought; work as in previous task
  5. calculate the cost also with GDP
  6. calculate the total cost without and with GDP
  7. using function MIN get the price of the cheapest item
  8. using function MAX find the price of the most expensive item
  9. sort the table from the cheapes to the most expensive item (according to the prices per item)