Theme 3 exercises: OPERATIONS WITH FILES


Exercise 3: Fruit sales.

1 Start a new workbook.

2 Create a book to perform an anticipation of sales for the rest of the semester, using the sales in January and the increase or decrease of these over the length of the semester. 

We know that:

Sales in February are 12% more than in January.

In March, 5% less than February.

In April, 10% more than March.

In May, 5% less than April.

In June, 15% more than May.

The model should appear the same as the figure seen below, taking into account that the blue cells contain formulas. They are only performed on strawberries, and in future exercises we will extend them to more fruits.

 

ejemplo venta frutas

3 Save the book in the My exercises folder of the hard drive, naming it Fruit sales.

4 Close the book.

 

If you are unsure of how to perform the previous exercise, we will explain it to you here.

 

 

Exercise 3: Fruit sales. II

1 Open the Fruit sales book in the My exercises folder of the hard drive.

We are going to extend the model.

2 Write TOTAL in cell H4.

3 Write the formula with which to calculate the sum of the strawberry sales in cell H5.

4 Save the book.

5 Close the book.

 

If you are unsure of how to perform the previous exercise, we will explain it here.

 



 
 

Ex.Page. 3.2

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.