Assume A4 has the formula =SUM(A1:A3). When the same formulae is copied to column B4 Relative Addressing automatically changes the formulae in B4 as =SUM(B1:B3 ). Relative here means that the reference to this area will be changed automatically when you copy the formulae. .
. Absolute Addressing Absolute Addressing is opposite to Relative Addressing. A dollar sign is placed before each column name and row number in an Absolute Addressing, for example, assume A5 has the formula =SUM($A$ :$A$ ) , when it is copied to B5 the reference will not automatically change and formulae in B5=SUM($A$ :$A$ ) that is same as A5. Figure: .
Relative Cells Addressing Figure: . Absolute Cell Addressing . – Functions in OpenOffice Calc . .
– Introduction A function is a predefined calculation entered in a cell to help to analyze or manipulate data in a spreadsheet. These functions simplify help to create the formulas needed to get the expected results. Formulae are equations using numbers and variables to get a result. In a spreadsheet, the variables are cell locations that hold the data needed for the equation to be completed.
Open Office Calc includes over functions to analyze and reference data. Many of these functions are used for working on numbers, dates, times, and text. . .
– Familiarization with the categories of functions The most commonly used functions are the built-in functions, which is available in .the Function Wizard. To open the Function Wizard choose Insert → Function or press the shortcut key Ctrl+F2 . . Once the Function Wizard is open, Select a Category from the Category dropdown box and select the function from the Function list box.
. When you select a function its description appears on the right-hand side of the dialog box. Double-click on the required function. .
The Wizard now displays a textbox where you can enter data manually in the text box and the result will be displayed in the Result text box Figure: . Function Wizard Dialoge Box . . – Working with the functions in Mathematical and Statistical Category .
. . - Mathematical functions under Mathematical Category: Various Mathematical