Page 263 - open office
P. 263

Formula with Cell Names

                 In  Calc , Formula can be applied with reference to cell names. For doing so, first define the name of the cell
                 or the range of cells.
                 For naming a cell, click on the cell and type the name for that cell in the address to replace the cell address
                 (co-ordinates) with the name and press the ‘Enter’ key. Name can be used directly in a formula.

                 For example: Consider a worksheet that has the following details:

                                  A                      B                  C                  D                 E

                   1     Name_of_Sales_Man         Sale in 2 15        Sale in 2 16       Sale in 2 1        Total_Sale

                   2        Kumar  arayan                                                                     25

                 In the address bar, assign the cell A1 as  ame of Sales Man, B1 as Sale in 2 15, C1 as Sale in 2 16, D1 as
                 Sale in 2 1  and E1 as Total Sale. Enter the values in the cells A2, B2, C2 and D2 as Kumar  arayan,      ,
                      ,       respectively.

                  ow, enter a formula in cell E2, say   Sale in 2 15   Sale in 2 16   Sale in 2 1 . After pressing the Enter
                 key, the output will be shown as 25     in cell E2 .

                 Formula with In-built Functions

                 Functions are in-built formula in ‘Calc’ that
                 can be used to perform arithmetical and non-                       =SUM(A1:A5)
                 arithmetical  tasks. In ‘Calc’, there are more
                 than 3 5 in-built functions that can be applied
                 directly or  as a part of a formula.  A function    Name                               Argument
                 contains ‘Name’ & ‘Argument’.
                 For Example: A formula, say as A6 A1 A2 A3 A4 A5 can be written using the  SUM  function along with
                 the cell range as: A6 SUM(A1:A5)

                   ame  is the name of the function that signifies the nature of operation.  Argument  specifies the values or
                 the range of cells on which the specific operation is being applied and is always enclosed within the opening
                 and closing parenthesis (i.e. Name refers to the operator and Argument refers to the operand).
                            N ot e s

                                                                         esent
                                                                         esent
                                                                      epr
                                                                      epr
                                                                                 betw
                                                                                 betw
                                                                              ed
                                                                              ed
                                                           f
                                                                 it
                                                           f
                                                            cells,
                                                            cells,
                                                                     r
                                                                     r
                                                                   is
                                                                 it
                                                                   is
                                                                                     een
                                                                                                             f
                                                                                                              the
                                                                                                           o
                                                                                                             f
                                                                                                              the
                                                                                                                   st
                                                                                                                   st
                                                                                                                 fir
                                                                                                                 fir
                                                                                                           o
                                                                                         colon
                                                                                               with
                                                                                     een
                                                                                         colon
                                                                                               with
                                                                                                        ess
                                                                                                        ess
                                                                                                    addr
                                                                                                    addr
                                         t
                                         t
                               orksheet,
                                           denot
                                         o
                                         o
                           In
                           In
                           In Worksheet, to denote a range of cells, it is represented between colon with address of the first
                               orksheet,
                             W
                             W
                                           denot
                                                  a
                                                  a
                                                    range
                                                    range
                                                 e
                                                          o
                                                          o
                                                 e
                           cell   last cell, i.e., say a range of cells from A1 to A5 will be denoted by A1 : A5 .
                           cell   last cell, i.e., say a range o f cells fr om A1 t o A5 will be denot ed by  A1 : A5  .
                           cell   last cell, i.e., say a range of cells from A1 to A5 will be denoted by A1 : A5 .
                           T
                           To apply function between the selected cells among the range of cells, a semicolon (;) is used,
                           To apply function between the selected cells among the range of cells, a semicolon (;) is used,
                                                                                         f cells, a semicolon (;) is used,
                                                              ed cells among the range o
                                                 een the select
                            o apply function betw
                                                               A1 A2  is applied.
                           i.e., for denoting two cells A1 and A2,  A1 A2  is applied.
                                             o cells A1 and A2,
                           i.e., for denoting tw
                           i.e., for denoting two cells A1 and A2,  A1 A2  is applied.
                   OPERATOR
                 An operator is a symbol that performs certain mathematical or logical operations. In a cell, the calculation
                 takes place in the order of precedence of operators (in a similar way as BODMAS in mathematics).
                 The table given below shows the operators, their meaning and their order of execution. When two operators
                 share the same ranking or precedence, calculation is done in the order from left to right.
                                                                                     Working with Spreadsheet       263
   258   259   260   261   262   263   264   265   266   267   268