Spreadsheets
Section2 Editing
Exercise1
Open a new Excel document and enter the following data:
2.1 Deleting a row or column
Exercise2
It has been decided that the figures for Wells are not required. Delete this row. (do
not leave a blank row)
Method
1. Click on: the row number that you want to delete (row 5). Check that row 5 is
highlighted.
2. Right-click on: the selected row; a pop-up menu appears.
Page 1 of 7 21 Aug, 2025
Spreadsheets
Click on: Delete.
3. The spreadsheet contents move up to occupy the empty space
and the figures and recalculated to reflect the change.
Note: If you want to just delete the cell contents and not the row,
select the cell and press: Delete.
Page 2 of 7 21 Aug, 2025
Spreadsheets
Excercise3
The figures for Tue are no longer required; delete this column.
Method
1. Click on: the column alphabet you want to delete
(column C). Check that column C is highlighted.
2. Right-click on: the selection; a pop-up menu appears. Click on: Delete.
2.2 Adding a new column and a new row
Exercise4
Tue
Insert a new column, headed Tue, after Mon and before Wed.
Bristol 489
Enter the information shown on the right:
Bath 328
Freshford 178
Limpley 375
Weston 845
Method
1. Click on: the column alphabet after where the new
column is to appear (column C); make sure that
column C is highlighted.
Page 3 of 7 21 Aug, 2025
Spreadsheets
2. Right-click on: the selection; a pop-up menu appears.
Click on: Insert. An empty column appears.
3. Enter the new text data shown above.
Calculate the TOTAL for Tue, using one of the methods you have learnt.
Page 4 of 7 21 Aug, 2025
Spreadsheets
Exercise5
It has been decided to re-insert the figure for Wells. Insert a new row for Wells
between Bath and Freshford. Fill the new row with the following information. Mon 120,
Tue 900, Wed 600, Thu 370, Fri 630.
Method
1. Click on: the number row below where you want the new row to appear, (row
5); make sure that row 5 is highlighted.
2. Right-click on: the highlighted row; a pop-up menu appears. Click on: Insert;
an empty row appears.
3. Enter the new text and data shown above.
Calculate the TOTAL for Wells, using one of the methods you have learnt.
2.3 Copying a cell
Exercise6
Insert a new row immediately after Bristol. Copy the whole data from Limpley and
paste it in the new row.
Method
1. Insert a new row right after Bristol.
2. Select the data from Limpley (cell A8 to G8).
3. Click on: Edit menu, select on Copy.
4. Select cell A4.
5. Click on: Edit menu, select on Paste.
2.4 Moving a column
Exercise7
Move the column headed Thu between Mon and Tue.
Method
1. Select the whole column of Thu (column E).
2. Click on: Edit menu, select on Cut.
3. Select the whole column of Tue (column C).
4. Right-click on the selected column; a pop-up menu appears. Click on: Insert
Cut Cells.
Page 5 of 7 21 Aug, 2025
Spreadsheets
Info
Move and copy using drag and drop
1. Select the cell where you want to move/copy.
2. Hover the mouse over the selection border; the mouse pointer appears.
Mouse pointer
3. To COPY: Hold down the Ctrl key; a + appears alongside the arrow.
To MOVE: skip Step 3.
4. Hold down the left mouse button and drag the selection to its new position.
5. Release the mouse.
2.5 Save your spreadsheet as Ex2 BRANCH SALES
2.6 Close the files and exit Excel
Practice2
Load Excel. On a new sheet enter the following data and follow the instruction bellow.
Note: In the ‘formula’ cells enter a formula for each month totals.
OFFICE ITEMS
Item Price Quantity Total
PENCILS 120 8 formula
BALL POINT PENS 99 12 formula
YEAR PLANNERS 370 8 formula
PUNCHED POCKETS 200 35 formula
RING BINDERS 860 2 formula
MESSAGE PADS 90 5 formula
Total formula
1. Delete the YEARS PLANNERS row.
2. Insert a new column headed Discount after Price and enter the following data.
PENCILS 30
BALL POINT PENS 17
PUNCHED POCKETS 100
RING BINDERS 280
Page 6 of 7 21 Aug, 2025
Spreadsheets
MESSAGE PADS 23
3. Change the formulas so that the discount affects the total.
4. Save the spreadsheet as P2 office items.
Page 7 of 7 21 Aug, 2025
