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

 



   
Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.