Latest articles and Revisions

Address modes

Address modes

When constructing spreadsheets using drag and drop techniques you need to be aware of the two difference address modes. Relative and absolute addressing. The following two examples will highlight the difference.

Drag and drop

Drag and Drop

Drag and drop techniques can take a little practise to master. To illustrate, start with a blank spreadsheet and select cell A2 by simply clicking in it once. Notice that the border changes to a bold outline and in the bottom right hand side is an Autofill (or drag ) handle.

drag

Spreadsheet

Working with Spreadsheets, cells and formulas

Recent experience with spreadsheets made me think it might be useful to explain to non users just how easy it is to use the features that are available with spreadsheets to log whatever data you wish. To show how brilliant spreadsheets can be I propose to explain how they can be used to keep track of say your bank account with a fully automated balance.

Spreadsheet terms

Spreadsheets - glossary of terms

Lets start by giving you some definitions of what you will see when you start an Open Office spreadsheet. It helps if you know the correct name for each tool and function.

Spreadsheet Active Cell

The Active Cell is the cell that you have selected. To work in a spreadsheet you need to have a cell active. This tells the computer where you want to work.

Spreadsheet precedence

Spreadsheet calculations - Order of Precedence

Formulas containing more than one arithmetic operator follow the order of precedence. A spreadsheet performs its calculations based on the following order:

  • Brackets
  • Order (e.g. Exponents or powers)
  • Division
  • Multiplication
  • Addition
  • Subtraction

One way to remember this is to remember the word BODMAS spelt out by the initial letters.

Brackets have the highest precedence (or priority) while subtraction has the lowest.