Page 266 - Trackpad IT-402_Class-IX
P. 266

The name of the application window i.e., OpenOffice.org Calc appears next to it. The control buttons, i.e., Maximize,
          Minimize and Restore and close are available on the extreme right of this bar.




        •  Menu Bar: The bar just below the Title Bar is the Menu bar. This bar has got different menus like File, Edit, View,
          Insert, Format, Tools, Data, Window and Help. Each menu is like a category that contains different related options
          that are used to perform different tasks.
        •  For example, the options related to the file such as New, Open, Save, Print, etc. are present in the File menu.




        •  Toolbars: Just below the menu bar, there is a set of three default toolbars which are explained below.
             w Standard  Toolbar:  It consists of some standard operations  which  are  common across all  the applications  of
            OpenOffice software. Some of these are New, Open, Cut, Copy, Paste Save, etc.



             w Formatting Toolbar: It consists of the tools used to format the spreadsheet. Formatting the spreadsheet includes
            the options like change of text colour, size, style, alignment, number formatting, etc.

                 Font Name       Font Size




             w Formula Bar: It is the most important bar in a spreadsheet and is used for entering and editing a formula.

                              Name Box     Function Wazard             Input Line












                                            Sum Button   Function Button

          It contains different options which are given as follows:
             w Name Box: It displays the name or reference of an active cell or a selected cell range.
             w Function Wizard: It is used to insert functions through interactive step-by-step processes.
             w Sum: It is used to insert a sum function directly for the currently selected cell range.
             w Function: It adds a formula to the current cell. If you click this icon then it changes to    and you are ready to
            enter a formula in the input line.
             w Input Line: It is used to enter a formula that needs to be applied in the current cell or selected cell range. It
            also displays the contents of the selected cell (i.e., data, formula, or function) and allows editing of the cell
            contents.
        •  Worksheet: A file in the OpenOffice Calc is known as a worksheet. The default name of the worksheet is “Untitled1”.
          Initially, it has three sheets (or sheet tabs) and more can be added or subtracted later as per the need.
           A worksheet is divided into rows and columns to form a grid of cells where data can be arranged in an organised
          manner.




          266   Trackpad Information Technology-IX
   261   262   263   264   265   266   267   268   269   270   271