Theme 6 Exercises: CELL FORMATS.


If Excel2003 is not open yet, open it in order to perform the following exercises.

 

Exercise 1: Precipitations III.

1 Open the Precipitations workbook in the My documents folder of the hard drive.

2 Modify the format of the cells so that the sheet is the same as the one seen below.

ejercicios precipitaciones

3 Close the workbook, saving the changes.

 

If you are unsure of how to perform any of the operations in this exercise, we will explain them here.

 

Exercise 2: Sales people III.

1 Open the Sales people workbook in the My documents folder of the hard drive.

2 Modify the format of the cells so that the sheet is more or less the same as the one seen below.

ejercicio ventas

3 Close the workbook, saving the changes.

 

If you are unsure of how to perform any of the operations in this exercise, we will explain them here.

 

Exercise 3: Race.

1 Start a new workbook.

The "Rush" club has organised a bicycle race. The participants have different types of bicycles, and so the time used to cover the race is multiplied by a compensation factor so that the result is fair. The organisers of the race want to implement a model that allows them to calculate the race times and be able to elaborate a list of classifications.

2 The model should look similar to the one seen below, keeping in mind that the light blue cells are formulas.

 

ejercicio carrera

3 Close the workbook, saving the changes and naming it Race in the My documents folder of the hard drive.

 

If you are unsure of how to perform any of the operations in this exercise, we will explain them here.

 

Exercise 4: Thefts

1 Open the Thefts workbook in the My documents folder of the hard drive.

2 Perform the appropriate changes so that the document remains in the following format:

3 Close the workbook, saving the changes.

If you are unsure of how to perform any of the operations in this exercise, we will explain them here.

 

Exercise 5: Multiplication table

1 Open the Multiplication workbook in the My documents folder of the hard drive.

2 Perform the appropriate changes so that the document remains in the following format:

3 Close the workbook, saving the changes.

If you are unsure of how to perform any of the operations in this exercise, we will explain them here.

 



 
 

Ex. Page. 6

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.