Part – III Working with Functions and Chart . Functions OpenOffice Calc has more than functions under categories. Functions are predefined formulae already available with Calc. They are used to perform several frequently done calculations.
Every function has a unique name and a prototype. Functions are categorized according to their functionality. For example, the functions such as Sum, Average, Sin, Cos etc., are categorized as “Mathematical Functions”. .
. Inserting Functions into Worksheet: A function can be inserted by (i) Direct Insert Method or (ii) Using Function Wizard method. . .
. Direct Insert method: If you know the function name and its syntax, it can be directly typed in any cell of the worksheet. For example, SUM is the most frequently used function to add a set of values. The syntax of the SUM ( ) is = SUM (range ; range ; range …… range n) If you want to know the sum of the values in A1, A2, A3, A4 and in A5, Place your cell pointer in A5 and directly type the formulae as follows.
= SUM (A1:A4) While inserting a function the following points should be kept in mind. . A function should begin with an equal sign. .
Use proper name for the function to be used. . Arguments should be given within the brackets as per the syntax. Each function has a unique argument list.
. Press “Enter” key after typing the function.