Page 57 - TechPluse_C6_Flipbook
P. 57

Step 4     Drag the mouse pointer over the cells you want to include in the series. The cells
                            display the number series automatically. This feature can be used to fill series of odd
                            numbers, even numbers, number series, days of a week, months of a year, etc.













                                           Applying        Number series       Days in a week
                                            AutoFill       using AutoFill      using AutoFill
                       Restart



                      LibreOffice Calc is an application software to store and analyse numerical data.
                      Vertical divisions are called columns whereas the horizontal divisions are known as rows.
                      The intersection of a row and a column is called a cell.
                      The contents of a cell can be moved or copied to another cell.
                      Two or more cells can be merged into one cell.
                      We can split the merged cells.
                      There are many options available to format your Calc workbook, which can make the
                      worksheet attractive.
                      AutoFill is a feature in LibreOffice Calc which allows user to fill automatically any number
                      or text series.



                                                          Checkpoint



                 A.    Tick ( ) the correct option.
                       1.   Which formatting elements are included in the format menu?
                            a.   text wrap                              c.  merging cells
                            b.   column width                           d.  all of these

                       2.   Vertical divisions are called ...........................
                            a.   rows                                   c.  cells

                            b.   columns                                d.  sheets
                       3.   What does an intersection of a cell includes?
                            a.   row                                    c.  both a. and b.

                            b.   column                                 d.  none of these

                       4.   Which option of Format menu allows you to add borders to the selected cells?
                            a.   Borders                                c.  Colors
                            b.   Cells                                  d.  Cell Border



                                                                                      More on LibreOffice Calc       55
   52   53   54   55   56   57   58   59   60   61   62