The ABC Study Guide, University education in plain English alphabetically indexed. Click here to go to the main index, or the ABC image for the cover

A spreadsheet is a computer program that does calculations on figures in rows and columns.

 Rows go across

Columns go up and down:
 The basic screen design of a spreadsheet is a table of rows and columns. The oblongs made by the intersections of the rows and columns are called cells. Each of these cells has a name (address) that is made by putting the name of the column with the name of the row. Cell B3 is the cell at the intersection of column B and row 3.

 Cells are labelled: alphabetically from left to right: A,B,C, etc Numerically from top to bottom: 1,2,3 etc A1 B1 A2 B2 A3 B3

Percentages
The formula for a
percentage is:
number divided by total, all multiplied by one hundred
If you look at the above diagrams you will see how a formula is entered in a cell to calculate this in a spreadsheet.
The formula (B2/B6)/100 in the example will work perfectly well
But, if you copy it to other cells you need to mark the cell reference for the total (B in this example) so that it does not alter when you copy it. In Excel spreadsheets this is done by putting a \$ before the letter and number of the cell reference you want to stay the same. So the formula becomes: (B2/\$B\$6)/100

Normally, if you copy a formula from one cell to another in a spreadsheet it uses intelligent calculations to alter it to what you are likely to want. It uses relative rather than absolute positions. So, if you copy the formula down a row, instead of copying B2/B6, it will enter B3/B7. With percentages, you want it to do this with the number (B2 to B3), but to use the same total address each time (B6)

As well as the specialist spreadsheet programs that do this, wordprocessors often include a simple spreadsheet as a tool. In WordPerfect 5.1 and Wordperfect for Windows it is an aspect of tables. This is very useful if you need to include a table of figures in an essay.

 External link to a site where you can try these ideas out and find out much more: "What is a spreadsheet? on MathsNet

## Notes on the Excel spreadsheet

• clicking on the grey button at the top of a column highlights the whole column

• clicking on the grey button at the left of a row highlights the whole row

• clicking on a cell gives it a black border. This means that the cell is active - which means you can enter things in it from the keyboard.

• You can enter words or numbers

• If you enter words as headings, they will appear to stretch across several cells. You can adjust the row or column to fit by using the format menu or by mouse movements between the grey cells at the top or left side.

• If you laid out a spreadsheet with headings down the side and headings across the top - ready to enter data - you could call that a template

• When you create a template, or enter data, you should name your spreadsheet by saving it to your disk. Simple eight letter names are best for computer files. So, if your spreadsheet shows crime statistics for 1981 and 1994 you could save it as crime8194