Commonwealth Computer Navigator's Certificate
Module 4 : Spreadhseets using OpenOffice 3.0 Back to Module 3 : Word Processing using OpenOffice 3.0 Writer 
Getting to know the application 
Working with and in cells 
Managing Worksheets 
Working with Formulas and Functions 
Formatting cells 
Creating charts and graphs 
Preparing the spreadsheet for distribution

Section 4.4: Working with Formulas and FunctionsSection OverviewWe are now at the stage where we can undertake the main tasks that spreadsheets are designed to support, namely to automate numeric operations and to store the output of those operarions for later use. Such operations are needed in a range of realworld situations. For example, teachers may be required to do a simple analysis of the performance of their students in endofsemester examinations. Alternatively, school administrators may be required to devise some basis for distributing a limited number of laptops to students and would need to generate numbers of students who meet some predetermined criteria. Overall spreadsheets allow for the generation of quantitative data in a variety of contexts. Two of the primary tools used for this purpose are formulas and functions.
Outcomes
The following subsections are covered in this tutorial: 