Page 78 - PlugGPT_V2.0_C5_Flipbook
P. 78

Number: It includes the digits (0–9) and their different combinations. All types

                       of calculations can be done on numbers. By default, the numbers are right
                       aligned in a cell.
                      Text: It includes the collection of letters, numbers and special characters. No

                       mathematical  calculation  can  be  performed  on  text.  By  default,  text  is  left
                       aligned in a cell.

                      Date: This is used to enter dates in various formats, with the default format
                       being mm/dd/yy.

                      Time: It is used to enter time in either hh:mm or hh:mm:ss format.

                      ENTERING DATA IN SPREADSHEET

                  Most of the data are entered using keyboard. To enter data, follow these steps:

                  Step 1     Click on the cell where you want to enter the data and start typing.
                  Step 2     You will notice that the same data is displayed in the Formula bar.







                                                                   2


                                                1







                      USING AUTOFILL FEATURE

                  When a series of number has to be entered then AutoFill feature of LibreOffice Calc
                  speed up the data entry. To use AutoFill feature, follow these steps:
                  Step 1     Type      first    number.

                             Move the cursor to the
                             bottom  corner  of  the
                             cell. The cursor changes
                                                                         1
                             into a plus shape.
                  Step 2     Drag  the  cursor  down

                             (or  across)  to  fill  the
                             series  to  the  desired
                             range of cells.


                                                                          2




               76       Premium Edition-V
   73   74   75   76   77   78   79   80   81   82   83