CCNC/CCNC Module 4/Working with Formulas and Functions

{| id="mp-upper" style="margin:5px 0px 0px 0px; background:none;"
 * class="MainPageBG" style="width:5%; border:10px solid #FBEBF5; -moz-border-radius: 8px;background:#f5fffa; vertical-align:top; color:#000;" |

Section Overview
We 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 end-of-semester 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 pre-determined 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.

The following sub-sections are covered in this tutorial:
 * Arithmetic formulas
 * Error values when using formulas
 * Cell referencing
 * Working with functions
 * Using the logical function IF