Excel is a spread sheet calculator A FORMULA: =2.54*A2 area of a circle: P=pi*radius^2 cuboid: V=abc S=2ab+2ac+2bc input output a= 24.4 cm b= 12.2 cm 45 0.505617978 c= 6.1 cm 3 44 98.6 9.92975327 S= 1041.88 cm2 V= 1815.848 cm3 ##### Sheet/List 2 ##### Prepare a simple calculator of shopping price with value added tax valid in Greece. Replace data in columns G-L with FORMULAS. "to check correctness of rows, you may compare your values to " http://www.calkoo.com/?lang=3&page=8 Greece Value Added Tax "From July 1, 2010 VAT in Greece is 23%" "There is a reduced rate of 13% that applies, in the main, to food, medicines. The V.A.T rate for hotel accommodation, books and newspapers is 6.5%." calculation of INPUT OUTPUT V.A.T. unit price qty total price 23 13 6.5 % TOTAL without tax without tax TAX price with tax bread 3.10 1 3.10 0.40 3.50 coffee 21.98 2 43.96 5.71 49.67 coke 2L 2.30 10 23.00 2.99 25.99 book 9.35 1 9.35 0.61 9.96 newspaper 1.50 1 1.50 0.10 1.60 cigarettes 6.25 2 12.50 2.88 15.38 chew.gum 0.95 5 4.75 1.09 5.84 ouzo 12.12 3 36.36 8.36 44.72 134.52 12.33 9.11 0.71 156.66 EUR to be paid ##### Sheet/List 3 ##### "month of the year" "average max. temperature °C" "average min. temperature °C" "average sea temperature °C" 1 10 5 13 2 11 5 12 3 14 7 13 4 18 11 14 5 23 16 17 6 27 19 21 7 30 22 23 8 30 22 23 9 26 19 22 10 20 14 21 11 15 10 18 12 12 7 15