## Spreadsheets[ GCSE.com | Glossary ] | |||||||||||||||||||||||||||||||

Spreadsheets are
formula. This is just the same as the scientific relationship, e.g. those above, but is understood by the computer. The following table was created in 1 minute:
## Table 1Spreadsheet tables are separated into cells (a grid of boxes). In the example above, we have cells with Text, Numbers and Formulas. We refer to a cell by the Column LETTER followed by the Row NUMBER. Thus, cell 'a1' contains the text: "Current, I (amps)", and cell 'b4' contains the number "1·5". When we enter forumlæ, we refer to cells containing numbers and perform mathematics on them. For example, the cell d2 needs the formula (a2*d2). So, only Current and Voltage were entered into the sheet, Resistance was found by entering (b2/a2) in cell c2, and copying this formula into the rest of the table. Power was found in a similar fashion, i.e. (a2*b2). A * is used to mean multiply, and / to mean divide. When you include spreadsheet tables in a write-up, you should always explain what you are getting the spreadsheet to do. Most spreadsheet packages use a similar method of formula entry to that above - refer to your own manuals if in doubt.
- It is rare that we need to use more than 2 numbers after the decimal point.
- Centre your column headings, and results.
- Use
**bold**type for headings, or important results. - Make sure you include the unit name, or symbol. If in doubt, use
*both*! - When you print your tables out, make sure they fit onto
*one*sheet of paper and also ensure the vertical lines separating columns are printed.
The table below (table 2) shows an example that you should follow:
## Table 2Spreadsheet tables often print terribly. You will have saved time on calculations, but the final result can be disappointing. Exporting the spreadsheet as a comma separated variable (CSV) file, into a specialised table creator (e.g. the RISC OS ## NEXT: DTPLast updated Wednesday 21st February 2001 |