Page 216 - IT_Play_V1.0 Class9
P. 216

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.
              Status Bar


              It lies at the bottom of the screen. It shows the current status of an active application.
              Sheet Tab

              It lies below the active sheet of the screen. The names of the sheets appear in the sheet tabs at the bottom of
              the spreadsheet. Click on the specific sheet tab to open it.

              Horizontal Scroll Bar
              It lies below the sheet tabs. It helps to view the spreadsheet screen by moving the scroll button from left to
              right and vice-versa.

              Vertical Scroll Bar

              It lies towards the right side of the spreadsheet. It helps to view the spreadsheet by moving the scroll button
              from top to bottom and vice-versa.

              Control Buttons

              Control buttons are essential interface elements that allow users to execute commands, such as minimizing,
              maximizing, or closing a window.
                RANGE OF CELL

              A group of cells is known as a cell range. A range comprises of two or more selected cells and those selected
              cells need not be adjacent to each other. Rather than a single cell address, you will refer to a cell range using
              the cell addresses of the first and last cell in the cell range separated by a colon. For example, a cell range that
              includes cells A1, A2, A3, A4, and A5 would be written as A1:A5. Different types of cell ranges are:








                214     Information Technology Play (Ver 1.0)-IX
   211   212   213   214   215   216   217   218   219   220   221