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

Return to the exercise without resolving

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)

Return to the exercise without resolving