- Nicholas Lee,
- Andrew Millman
Spreadsheets form part of a family of tools for storing and manipulating numerical data. At their most basic, they perform the simple arithmetical calculations normally done on a handheld calculator. Several good programs are available that will simulate such calculators. Many of the calculator programs available provide facilities such as scientific functions, weight and measure conversions, and statistical and financial functions. They are often included in a package with other programs such as Windows or WordPerfect.
If you need to perform multiple calculations on a collection of data a spreadsheet program becomes invaluable. Spreadsheets were used before computers for bookkeeping and business accounts. However, maintaining accuracy when adding or performing the calculations on the figures within a spreadsheet was always a problem. A computer spreadsheet overcomes this problem. The calculations are always accurate, and if you make an alteration in a massive spreadsheet, the hundreds of calculations required to update the figures and totals are done in seconds.
WordPerfect's calculator can be turned on by running the macro calc.wpm.
Structure of spreadsheets
A spreadsheet consists of columns labelled on the top A, B, C, D … and rows labelled on the left 1, 2, 3, 4…. The cells within the table are identified by the column and row label--for example, A1, A2, B1, B2. The column letter always goes first. You can enter numbers, formulas, or words into the cells. Entering a formula instructs the spreadsheet to carry out a calculation on data in other cells. For example, to add all the numbers in a column you would enter the formula B1+B2+B3+B5+B6+B7 into the cell you wish the total to be placed or more simply use the summing function. If any of the numbers are altered the spreadsheet automatically recalculates the total.
The sum function is a quick way of adding up data …
Sign in
Article access
Article access for 1 day
Purchase this article for £20 $30 €32*
The PDF version can be downloaded as your personal record







CiteULike
Connotea
Del.icio.us
Digg
Facebook
Mendeley
Reddit
Technorati
Twitter
Stumbleupon
Rapid responses
Latest Responses
Re: Bringing Nightingale down to size
Published 29 May 2012
Re: Avoid antimuscarinic drugs in people with dementia
Published 29 May 2012
Re: Strengthening primary health care: Related to the integration of medical training, community service need and health administration
Published 29 May 2012
Re: Strengthening primary health care: Related to the integration of medical training, community service need and health administration
Published 29 May 2012
Health Literacy: Patient involvement and engagement with healthcare
Published 29 May 2012
Most responses
Venous thrombosis in users of non-oral hormonal contraception: follow-up study, Denmark 2001-10 (12 responses)
Published 10 May 2012 - 23:32
The psychiatric oligarchs who medicalise normality (9 responses)
Published 2 May 2012 - 15:42
Are doctors justified in taking industrial action in defence of their pensions? No (8 responses)
Published 8 May 2012 - 12:21
Are doctors justified in taking industrial action in defence of their pensions? Yes (8 responses)
Published 8 May 2012 - 12:21
The hardest thing: admitting error (7 responses)
Published 2 May 2012 - 12:27