Theme 8 Exercise help. Working with rows, columns, cells, and sheets.


Exercise 1: Fruit sales IV.

In part 2 we are asked to insert a between the peach and the pear rows, and so:

1 Select the row where the new row is to be placed, that is, row 7.

2 Go to the Insert menu.

3 Select the Rows option.

 

In part 3 we are asked to insert 2 consecutive rows, and so:

1 Select rows 11-12.

2 Go to the Insert menu.

3 Select the Rows option.

The two rows are automatically added.

 

In part 4 we are asked to insert a column, and so:

1 Select column I.

2 Go to the Insert menu.

3 Select the Columns option.

 

 

In part 5 we are asked to insert a sheet, and so:

1 Click on the sheet following Sheet1 to select it, that is, Sheet2 (as the sheets are added to the left of the selected one).

2 Go to the Insert menu.

3 Select the Worksheet option.

 

In parts 6 and 7 we are asked to insert various cells, and so:

1 Select the range A6:B7.

2 Go to the Insert menu.

3 Select the Cells... option.

A dialog box will appear.

4 Leave the Shift cells down option activated.

5 Click on OK.

6 Select the range A6:B6.

7 Go to the Insert menu.

8 Select the Cells... option.

A dialog box will appear.

9 Leave the Shift cells right option activated.

10 Click on OK.

 

 

In part 8 we are asked to save the changes with a different name:

1 Go to the File menu.

2 Select the Save as... option.

A dialog box will appear.

3 Write the new file name, Modified fruit sales.

4 Click on Save.

5 Close the workbook.

In parts 8 and 9 we are asked to eliminate ranges B4:C4 and A6:A8, and so:

1 Select the range to delete, B4:C4 .

2 Go to the Edit menu.

3 Select the Delete... option.

A dialog box will appear.

4 Leave the Shift cells left option activated.

5 Click on OK.

6 Select the range A6:A8 .

7 Go to the Edit menu.

8 Select the Delete... option.

A dialog box will appear.

9 Leave the Shift cells up option activated.

 

10 Click on OK.

 

In part 10 we are asked to eliminate column I :

1 Select column I .

2 Go to the Edit menu.

3 Select the Delete option.

 

In part 11 we are asked to delete rows 7, 11, and 12:

1 Select the rows to delete, 7, 11 and 12 (using CTRL).

2 Go to the Edit menu.

3 Select the Delete option.

The three rows are automatically deleted.

 

In part 12 we are asked to delete the empty sheets in the workbook:

1 Select the sheets to delete.

2 Go to the Edit menu.

3 Select the Delete sheet option. If the option does not appear situate yourself over the button so that the menu unfolds.



 
 
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.