Page 77 - PlugGPT_V2.0_C5_Flipbook
P. 77

Scroll Bar

                 There are two scroll bars in the Window. The Vertical Scroll bar to move up and
                 down and the Horizontal Scroll bar to move Right and Left on the worksheet.

                 Status Bar

                 This bar gives us the information of the Spread sheet. It has the following information:

                    Position in the Document                           Current Page Style

                    Insert Mode                                        Selection Mode
                    Document Notification                              Digital Signature

                    Standard Formula                                   Zoom level

                 Rows

                 Horizontal line of cells is called a row. A row in Calc spreadsheet is numbered
                 1,2,3 so on. There are 1,048,576 rows in a Calc spreadsheet, this makes it popular
                 among large data users. Row numbers are displayed in the Left-hand side as
                 row header.

                 Columns

                 Vertical lines which run through entire spreadsheet are called columns. Columns

                 are addressed as A, B, C and so on. The Column names are displayed just below the
                 formula bar in the column header.

                 Cell

                 Intersection of a row and a column is called a cell. The entire spreadsheet is filled
                 with cells which hold the user data.

                 Cell Address

                 Cell address is a reference address of a cell. It is combination of column name and
                 row number. If we say A1 means we are referring to the cell address of First column
                 and First row. A Cell address is very important part of a Calc Spreadsheet as all the
                 formula and data entered in a cell is referred as its cell address.

                 Active Cell


                 The currently selected cell is called the Active cell. We can identify it by its coloured
                 cell border.

                     DATA TYPES IN LIBREOFFICE CALC

                 While  working  in  LibreOffice  Calc,  following  types  of  data  can  be  entered  in

                 spreadsheet.



                                                                                Introduction to LibreOffice Calc     75
   72   73   74   75   76   77   78   79   80   81   82