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

