Page 53 - IT-802_class_12
P. 53

Ð ÐMacros, for recording and executing repetitive tasks (scripting languages supported include OpenOffice.org Basic,
              Python, Bean Shell, and JavaScript)

            Ð ÐThe ability to open, edit, and save Microsoft Excel workbooks.
            Ð ÐImport and export of spreadsheets in multiple formats, including HTML, CSV, PDF, and PostScript.

              3.3 GETTING STARTED WITH OPENOffICE CAlC

            In this section, we will discuss how to start OpenOffice Calc and the components of the Calc window. We will also learn
            how to create a new spreadsheet and save it.
            To start OpenOffice Calc, perform the following steps:
             1   Click on the Start button.
             2   Click on the OpenOffice folder from the Start menu.

             3   Select the OpenOffice Calc application. Calc opens with a blank spreadsheet as shown:

                                                                                                    Title bar
                     Menu Bar
                                                                                                     Standard
                                                                                                     toolbar
                     Active cell                                                                    Formatting
                     reference                                                                       toolbar
                    (Name box)
                                                                                                    Formula bar
                      Active cell                                                                    Column
                                                                                                     Header

                   Row Headers


                    Sheet tabs


                                         Status bar

            You can also start OpenOffice Calc by double-clicking on the    icon from the desktop and then clicking on the
            Spreadsheet option.
            3.3.1 Components of a Spreadsheet

            The following are the components of a spreadsheet:

            Ð ÐSpreadsheet, Worksheet, and Sheet Tabs: A spreadsheet consists of worksheets. A worksheet is the working area
              or page on the screen. By default, a spreadsheet opens with three worksheets, namely Sheet1, Sheet2 and Sheet3.
              The user can change the names of the sheets and may delete or add extra sheets if required. The name of each
              sheet appears in the sheet tab at the bottom of the worksheet. The active sheet, i.e., the sheet being used, is
              highlighted. In the above figure, Sheet1 is the active worksheet.

            Ð ÐTitle Bar: It is located at the top of the window screen. It displays the name of the active spreadsheet. When the
              spreadsheet is newly created, by default it is named as Untitled1, the second is Untitled2, and so on.

            Ð ÐMenu Bar: It lies below the title bar in the active window screen. It contains different menus which have many
              options to perform various operations. If you click on them or press Alt along with the underlined character of the
              menu name, then the specific menu opens with its relevant options.

            Ð ÐStandard Toolbar: It is usually located below the menu bar. It contains shortcut buttons for frequently used options.
              By clicking on any of them, the option is directly executed.


                                                                                                   ICT Skills-IV  51
   48   49   50   51   52   53   54   55   56   57   58