Page 62 - Web_Application_v2.0_C12_Fb
P. 62

For example, selecting SUM allows you to type the range of cells to sum, such as A1:A5. By default, the
                 Select Function tool in LibreOffice Calc typically opens with the SUM function selected.
                Formula: In LibreOffice Calc, the = symbol initiates a formula or function. It tells Calc to interpret the
                 following text as a formula rather than a regular piece of text or a number. For example:
                 •  =A1+B1 adds the values in cells A1 and B1.
                 •  =SUM(A1:A5) calculates the total of the values in cells A1 through A5.

                The = symbol is essential for enabling calculations and functions in spreadsheet cells.
                Input Line: It displays the contents of the selected cell (data, formula, or function). It allows editing of the
                 cell contents. Click in the area and, then type the changes. To edit within the current cell, just double-click
                 in the cell.

              Spreadsheet and Sheet
              A spreadsheet consists of sheets. Spreadsheet is the working area or page on the screen. A Spreadsheet
              consists  of  rows  and  columns.  (A  Spreadsheet  is  like  a book and sheet is  like  a page  of a book).  By  default,  a
              spreadsheet opens with one sheet namely Sheet1. Users can change the name of the sheets and delete or
              add extra sheets if required. The name of each sheet appears in the sheet tab towards the bottom of the
              spreadsheet. The active sheet i.e. the sheet being used, is highlighted.

              Rows
              Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position. They are
                                                                                                           20
              numbered from top to bottom along the left edge of the spreadsheet. There are 10,48,576 (2 ) rows in a
              spreadsheet of LibreOffice Calc. The rows are numbered as 1,2,3,4,... .

              Columns
              Columns are the vertical set of rectangular boxes that are placed adjacent to each other in a vertical position.
              Columns are labelled from left to right. There are 1024 (2 ) columns available in LibreOffice Calc.
                                                                     10
              Cells

              A rectangular box formed by the intersection of a row and column is called a cell. Cell is the basic unit of a
              spreadsheet where data (numbers, text, formulas, etc.) are entered.

              Active Cell
              The selected or activated cell is referred to as the active cell which is always highlighted with a thick border.
              The address of the active cell is displayed in the name box for example, A1. In a spreadsheet, active cell is the
              place where data is entered. Before entering any data in the cell, it has to be first selected by placing a cursor
              on it. Then, when we position the mouse cursor on a cell, it gets selected and is ready to take data from the
              user or perform editing.


              Cell Address
              Each cell has a unique address which 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’.

              Sidebar

              The sidebar in LibreOffice Calc provides quick access to various features, including Properties, Styles, Gallery,
              Navigator, and Functions, allowing users to efficiently manage and format their spreadsheets.

                60    Touchpad Web Applications (Ver. 2.0)-XII
   57   58   59   60   61   62   63   64   65   66   67