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

