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

