Page 121 - TechPluse_C5_Flipbook
P. 121

Status Bar

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

                 a.  Position in the Document                             b.  Current Page Style
                 c.  Insert Mode                                          d.  Selection Mode

                 e.  Document Notification                                f.  The Digital Signature

                 g.  Standard Formula                                     h.  Zoom
                 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 dark cell
                 border.


                     DATA TYPES IN LIBREOFFICE CALC

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

                    Number: It includes the digits (0–9) and their different combinations. All types
                     of calculations can be done on numbers. By default, the numbers are right
                     aligned in a cell.





                                                                                Introduction to LibreOffice Calc     119
   116   117   118   119   120   121   122   123   124   125   126