Page 215 - IT_Play_V1.0 Class9
P. 215

Formula Bar

                 Formula bar lies below the formatting toolbar. Formula that performs different calculations in cells is entered
                 and displayed here. It is denoted by 'fx'.
                                     Function Wizard Formula



                             Name Box   Select Function      Input Line

                 It is used for  entering and editing the formula in the cell. Formula bar consists of:
                   Name Box: It displays the cell reference, for example A1 or D10.
                   Functions Wizard: It consists of a list of available functions that we can search .

                   Select Function: Click  the Select Function    drop-down list in the Formula bar opens a list of functions.
                   You can quickly select common functions like Sum, Average, Min, Max and so on. After choosing a function,
                   its name appears in the formula bar. Enter the required arguments directly in the formula bar or in the cell.
                   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
                 numbered from top to bottom along the left edge of the spreadsheet. There are 10,48,576 (2 ) rows in a
                                                                                                             20
                 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
                             Notes

                            In LibreOffice Calc, the first column is labeled as 'A' and the last column i.e. 1024th column is labeled
                            as 'AMJ'.





                                                                                             Create a Spreadsheet   213
   210   211   212   213   214   215   216   217   218   219   220