Page 308 - TP_IT_V1.0_C9_flipbpookl
P. 308

Tick ( ) if you know this.

                        Labels in a cell are always left aligned by default.
                        Values in a cell are always right aligned.

                        Formulas always begin with an equal = sign.





                      WHAT ARE FUNCTIONS?

              A function is a pre-defined formula in a spreadsheet that has a name followed by parentheses. For example, MAX(),
              MIN(), SUM(), etc. We write the arguments of the function inside the parentheses in the form of values, cell addresses,
              or cell ranges, so that the output of the function is generated based on the given arguments. A comma (,) is used to
              separate the arguments in a function.
              Spreadsheet applications contain various functions to meet the needs of different fields.

              The different ways of writing functions are listed below:
              •  When values are in a continuous range of cells
                =Min(D7:D11)

              •  When values are scattered in different cells
                =Min(D7,E12,Y56,B32)
              •  When values are constants
                =Min(100,200,3452)
              •  When values are a combination of cell range and a different cell address
                =Min(D7:D10,G40)
              •  When values are a combination of constant and cell address
                =Min(120,D9:D11,R12)
              Functions simplify the process of calculations and can be used to perform simple and complex calculations. The name
              of the function in LibreOffice Calc is not case-sensitive.

              Let us now do some of the commonly used functions using the given sheet:











                                                                                                 To open the
                                                                                                 Function Wizard:
                                                                                             Short key  Ctrl  +  F2












                306   Trackpad Information Technology (Ver. 1.0)-IX
   303   304   305   306   307   308   309   310   311   312   313