Page 275 - Trackpad IT-402_Class-IX
P. 275

The selected row gets deleted.




                   Tick ( ) if you know this.

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

                      Formula always begin with an equal = sign.





                    WHAT ARE FUNCTIONS?

            A function is an already created formula in a spreadsheet that has a name followed by circular brackets. For example,
            Max(), Min(), Sum(), etc. We write arguments of the function inside the brackets in the form of values, cell address or
            cell range, so that the output of the function will be generated based on the given arguments. A semicolon (;) is used
            to separate the arguments in a function.

            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)

                                                                                          Electronic Spreadsheet  275
   270   271   272   273   274   275   276   277   278   279   280