Page 203 - CA_165_V2.0_C9_Flipbook
P. 203

To create a Numeric data series:
                 Step 1:     Enter the first two values of series in adjacent cells.

                          The difference between the two numbers specifies
                          the increment/decrement value, and the first number
                          determines the  starting  number  for  the  series. For
                                                                                             Drag
                          example, if the first two numbers are 10 and 25, then
                          the increment value is 15 and the starting number is
                          10.

                 Step 2:   Select the first two cells and click AutoFill handle
                          tool and drag it to enclose the cells to be filled with
                          the series of numbers.

                 Step 3:     Release the mouse button. The range of cells will be filled with the consecutive number of
                          series. (Arithmetic and Geometric progression can also be created and inserted automatically
                          using this feature).

                 Custom List
                 ‘Calc’ also provides a feature to create a custom list where some series of names or text that can be
                 predefined and then it can be displayed when the initial data is entered and AutoFill is applied. A user
                 can create his own list as per his needs, such as a list of a company’s branch offices. After creation of
                 the customised list, it can be used to fill in a range of cells. In such a case, just enter the first name in
                 the list and with the help of AutoFill feature drag the mouse, the predefined series will be displayed. To

                 create a Custom list:
                 Step 1:   Select Options from the Tools menu. Options dialog box appears on the screen.

                 Step 2:   Click on the + beside OpenOffice Calc.
                 Step 3:   Click on Sort Lists to display predefined series of list.





                                                                                                                 4

                                2
                                                     3













                                      1

                 Step 4:   To generate own list, click on the New button.
                 Step 5:     Fill the series in entries section and then click on Add button to insert the user defined entries
                          in the list. The series can be utilised later in the spreadsheet.


                                                                                    Working with Spreadsheet     201
   198   199   200   201   202   203   204   205   206   207   208