Page 52 - Web Applications (803) Class 12
P. 52

Getting Started with Calc

              Once you install OpenOffice (www.openoffice.org), open Calc and you will see a screen as follows:
                                         Menu Bar   Formula Bar                   Tool Bar







                         Name Box





                       Selected Cell















              A worksheet with cells arranged in rows and columns is seen in the spreadsheet. We have entered some sample data in the
              preceding worksheet for better understanding. Let us now learn about the components of OpenOffice Calc window:

              1.   A row is a horizontal (sleeping) arrangement of cells. All math marks are on row number 4, as shown above. They
                  are numbered from top to bottom along the left edge of the worksheet. There are 10,48,576 rows in a worksheet of
                  Calc.

              2.   A column is a vertical (standing) arrangement of cells. Mamta’s marks are in column B, as illustrated above. Columns
                  are labelled from left to right. There are 1024 columns available in Calc.
              3.   A cell is a rectangle-shaped box formed by the intersection of a row and column. In a cell, you can type text,
                  numbers, dates, formulas, and so on. The highlighted cell is the one that has been chosen. The selected cell in the
                  Figure is D2, the cell in column D on row 2, and it contains Shweta’s English marks.
              4.   Each  cell  has  a  unique  address  that  identifies  its  location.  A  cell  address  is  identified  with  its  column  position
                  followed by its row number. For example, ‘A5’ is the cell address that is a combination of column ‘A’ and row ‘5’.
              5.   Each  cell  has  a  unique  address  that  identifies  its  location.  A  cell  address  is  identified  with  its  column  position
                  followed by its row number. For example, ‘A5’ is the cell address that is a combination of column ‘A’ and row ‘5’.
              6.   Whatever you input, it appears in the formula bar, as shown. You can also immediately input or change data and
                  formulas in the Formula Bar.
              7.   The location of the selected cell is displayed in the name box. The cell’s location is a combination of column and
                  row. For instance, B5, where B denotes the column name and 5 denotes the row number.
              8.   A worksheet is the working area or page on the screen. A worksheet consists of rows and columns. A collection
                  of worksheets is known as a workbook. (A workbook is like a book and worksheet is like the page of a book). By
                  default, a workbook opens with three worksheets, namely Sheet1, Sheet2 and Sheet3. User can change the name of
                  the sheets and may delete or add extra sheets if required. The name of each sheet appears in the sheet tab towards
                  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.


                    50      Touchpad Web Applications-XII
   47   48   49   50   51   52   53   54   55   56   57