Page 281 - open office
P. 281
The range of cells will be filled with the consecutive number of series. (Arithmetic and eometric 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 can be pre-defined
and then displayed when the initial data is entered and AutoFill applied. A user can create his own list as per
his needs such as a list of a company s branch offices. After the 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 the auto fill
feature, drag the mouse the pre-defined series will be displayed. To create a Custom list:
Step 1: Select ‘Options’ from the ‘Tools’ menu. The ‘Options’ dialog box appears on the screen.
Step 2: Click on the beside OpenOffice Calc.
Step 3: Click to display the pre-defined series of list.
2 3
Step 4: To generate own list, click on the ‘New’ button.
Step 5: Fill the series in the entries section and then click on the Add button to insert the user-defined
entries in the list; then click on the ‘OK’ button.
CHARTS AND GRAPHS
In the spreadsheet package, there are additional features that help to represent information in the form
of charts and graphs. It is a visual graphical representation of data from a worksheet that is very useful for
instant analysis of data and decision-making. There are various options of charts that can be used to display
in ‘Calc’ in graphical format.
Terms used in a Chart
X-Axis It is the horizontal axis known as the category axis.
Y-Axis It is the vertical axis and is known as the value axis.
The X and Y axis divides the X-Y plane into four quadrants.
Data series It is the set of values that the user wants to plot in the chart.
Chart Area It refers to the total area surrounded in the chart.
Formatting Cells in Spreadsheet 281

