Page 191 - CA 165 ver 1.0 Class 9
P. 191

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
                          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                    Drag
                          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 customized 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 Auto Fill 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 List’ to display predefined series of list.





                                                                                                           4

                                        2                   3


















                 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 utilized later in the workbook.





                                                                                    Working with Spreadsheet     189
   186   187   188   189   190   191   192   193   194   195   196