Part 2

Inserting and deleting rows and columns

Extra columns or rows can be [?] into the spreadsheet where required by selecting the location of the rows/columns and then exectuing the insert row or column command from the menus.

Complex formulae

It is possible to perform fairly complex calculations using pre-defined formulae - e.g. (or AVG), MIN, MAX. Also more complicated formulae can be created that add, subtract and use functions (such as AVERAGE) all in one formula, e.g. (B2/B3)+(B4*B5)+AVERAGE(C2:C5).

Alter column

In most spreadsheets there is a standard column width. Often the column width will have to be chnaged to allow more characters in a cell.

This can be done by dragging the edge of the column to make it wider or by selecting the column and then typing in a new width for it.

The way in which the cell stores information can be changed - e.g. we can chnage how the cell stores numbers (decimal places, percentages, [?] , etc.), the (right, left or centred) and the font (style of writing used).

Replicating

Often in spreadsheets a similar formula is required in several cells. Instead of typing these in each cell individually, it is possible to 'intelligently' copy these formulae. This form of intelligent copying is known as .

When a formula is replicated down one row, ALL the cell references in the formulae have one added to the rown number in their cell references (e.g. B6 becomes B7).

Similarly, when replicating across a column, ALL the column letters in the cell references are increased by one letter of the alphabet (e.g. B2 becomes C2).

So, for example, if the formula B2+B3 is replicated down one row, from cell E4 to cell E4, then the formulae will change to .

If the formula C4*C5 is replicated along one column, from celkl A2 to cell B2, then the formulae will change to .



Copying a formula to a number of cells in a row or a column is called . In this example (figure 12), the formulae in E3, E4, E5, etc.. are all similar.

If we had 5000 dwarfs instead of just 7, it would take ages to enter the formulae if there was not a quick method. The quick method is known as replication.

We enter the formula for F3 and replicate it into each of the other cells. The cell references in the formula are changed according to where the formula goes.

Alter

When you enter a value or formula into a cell then it is displayed using particular attributes. Some examples of these attributes are:

- Number of places
- Use of formatting (£, $, etc.)
- [?] of numbers/letters
- Size of numbers/letters, etc..