Latest articles and Revisions
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.
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.
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 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:
- Order (e.g. Exponents or powers)
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.
Formatting Drupal content
This page is provided as a guide for novice users, unfamiliar with HTML and CSS. It illustrates some very simple editing to show how to enhance the layout of a page. As well as standard HTML, some additional functionality is built into to theme to simplify the task of formatting, and to give the pages a consistent look and feel.