Page 24 - Touchpad_Plus_V3.2_Class 7
P. 24

This reference has 3 parts:
                  1. The workbook name and address in square brackets
                  2. The worksheet Sheet 1 preceded by #$ signs
                  3. The cell having relative reference preceded by period (.) sign
                  Hence,  referencing  cells  in  external  workbooks  is  done  by  selecting  the  workbook,  then
                  worksheet,and then the cell you want to link reference to.


                      FUNCTIONS
                  Functions are predefined formulas in Calc to perform both simple and complex calculations.

                  They accept arguments and return values. Arguments are input to functions. These values can be
                  number or text. The values are given in parenthesis. Return values display the function output.

                  Rules for using Functions
                      All Calc functions must begin with = sign

                      Function name must be a valid Calc name.
                      Function must be followed by opening and closing parenthesis.
                      Functions must contain an argument within it.

                  Type of Functions
                  LibreOffice Calc provides the following categories of functions:

                       Date & Time Functions: Calculates the day, month and year in a date and the hour, minute
                     and second in a particular time.
                      Logical Functions: Evaluates conditions such as Y < 3 and give the result as true or false.
                       Mathematical Functions: Calculates the square root or absolute value of a number, product
                     of numbers, etc.

                       Statistical Functions: Calculates the maximum, minimum, average, etc. of a set of numeric data.
                       Text Functions: Performs a number of operations on strings (i.e. a collection of characters
                     like 'hello', 'friend', 'computer', etc.) such as finding the length of a string, joining two strings,
                     searching for one string inside another etc.
                  Let us discuss these categories in detail.

                  Mathematical Functions

                  Some of the mathematical functions are given in the table below:
                            Functions                           Purpose                           Example

                   SUM(Number1, Number            It returns the sum of given           Input: =SUM(3,6,9,12)
                   2, …) OR SUM(Range)            numbers or a range.                   Output: 30

                   PRODUCT(Number1,               It multiplies the given values or a   Input: =PRODUCT(2,5,9)
                   Number 2, …) OR                range of cells.                       Output: 90
                   PRODUCT(Range)

                   MOD(Dividend, Divisor)         It returns the remainder after a      Input: =MOD(15,7)
                                                  dividend is divided by the divisor.   Output: 1



               22       Plus (Ver. 3.2)-VII
   19   20   21   22   23   24   25   26   27   28   29