Â鶹Éç

Once all the data has been put into the spreadsheet, Alistair can supply his manager
with information about the stock.

The toolbar

The toolbar contains a variety of tools to enable you to manipulate data and find information (the tools differ between software packages). A popular spreadsheet package has the following shortcut tools that will help you sort information out quite quickly:

	This tool will add up selected figures
	This tool will sort information from lowest to highest or alphabetically from Z to A
	This tool will help you put a chart together
	This tool will sort information from highest to lowest or alphabetically from A to Z

Another advantage of spreadsheets is that you can easily change information. If numerical information in the table is changed, the information linked to that cell will automatically be updated. For example: 'Sales' uses information from 'Price' and 'Sold' cells.

Sum in cell G2 is: =C2*F2

If another CD is sold, the values in columns D and F will change causing the Sales value to be updated. The table would look like this:

Go next to look at some tips on changing the look.