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
   276   277   278   279   280   281   282   283   284   285   286