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.
