Theme 4 Exercise help: FUNCTIONS.

 Exercise 1: Fruit sales III.
 In cell H5 we need to modify the formula =B5+C5+D5+E5+F5+G5 for =SUM(B5:G5) In cell J5 we want the kilo's of fruit sold in €/kg,, and so we need to put =H5*I5 Next we need to calculate the VAT on the strawberries, knowing that the % is in cell B14, and so in cell K5 we put =J5*B14. In cell L5 we need to total the price and the VAT, and so we put =J5+K5
 Exercise 2: Precipitation
 Here the formula in cell G5 corresponds the maximum value of days with rainfall in January, that is, =MAX(B5:F5) In H5 it will be the minimum value in January, and so we put =MIN(B5:F5) Now in cell B18, it will also be the maximum value of days with rainfall, but only in madrid, =MAX(B5:B16) And in cell B19 we put =MIN(B5:B16) Next in cell B21 corresponds the total number of days with rainfall in Madrid, and so, =SUM(B5:B16) In cell B22 we need to put the percentage of days with rainfall in Madrid with respect to the total number of days in the year, that is, =B21/365   And finally in A23 we need to put the average of days with rainfall in Madrid, that is, =AVERAGE(B5:B16)
 Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.