Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 44 - Data_Science_Part_A C12
P. 44

    3.3.5 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.

            3.3.6 Rows

            Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position. They are numbered
                                                                                   20
            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,... .

            3.3.7 Columns

            Columns are the vertical set of rectangular boxes that are placed adjacent to each other in a vertical position. Columns
                                                      10
            are labelled from left to right. There are 1024 (2 ) columns available in LibreOffice Calc.
            3.3.8 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.
            3.3.9 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.

            3.3.10 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’.
            3.3.11 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.

            3.3.12 Status Bar
            It lies at the bottom of the screen. It shows the current status of an active application.

            3.3.13 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.
            3.3.14 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.
            3.3.15 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.

               42   Touchpad Data Science-XII

| 39 40 41 42 43 44 45 46 47 48 49 |