Theme 5 Exercises. MANIPULATING CELLS (I).


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



Exercise 1: Fruit sales IV.

1 Open the Fruit sales wokbook, found in My documents in the hard drive.

2 Copy the range C5:H5 in the range C6:H12 without using the clipboard.

Observe how in the result it has also copied the format of the cells, and so deleted the previous format not necessary in his step.

3 Undo the previous operation.

4 Copy it again, this time without copying the format.

5 Copy the range J5:L5 in J6:L12 , using the paste special.

Observe what has happened in the VAT column. As the formula uses cell B14 which contains the VAT, on copying the formula in the lower cells, the formula varies and takes on in each case the cells B15, B16, B17...

 

What is it we need to do?

6 Copy it again in such a way that the folrmula keeps using B14 in all of the rows.

7 Save the changes and close the workbook.

 

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

 

Exercise 2. Precipitations II

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

2 Select cell A2.

3 Select the range of cells G4:H5 .

4 Select column C.

5 Select row 4.

6 Select from row 5 till 16.

7 Select jointly from A5 to cell A9.

8 Select the entire sheet.

9 Select row 4 and column A at the same time.

10 Select from cell A1 till cell F16 using the SHIFT key .

 

We will now practise copying formulas.

11 Finish the model by copying the formulas.

12 Save the changes and close the document.

 

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


Exercise 3: Sales people II.

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

2 Finish the model by copying the cells.

3 Finish the cell copying model.

Save the changes made and close.

 

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

 

More exercises on the theme in the next page...



 
 

Ex. Page 5.1

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.