Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 59 - 2505_CoreGPT(Podar)_Flipbook_C6
P. 59

    Row: The horizontal divisions on a worksheet are called rows. There are 10,48,576 rows in a

                        Calc worksheet.
                        Column: The vertical divisions on a worksheet are called columns. There are 1,024 columns in
                        a Calc worksheet.
                        Row  and  Column  Heading:  Work  area  is  divided  into  rows  and  columns.  The  rows  and
                        columns  are  referred  using  numbers  and  alphabets  respectively.  The  row  headings  range
                        from 1 to 10,48,576 and column headings range from A to AMJ.

                        Cell: The intersection of a row and a column is called a cell. A cell in Calc worksheet looks like
                        a rectangular box.
                        Active Cell: The currently selected cell that appears highlighted with dark orange border is an
                        active cell. The data is entered in an active cell.

                        Worksheet Tab: There can be more than one worksheet in Calc and each has a specific name.
                        Any worksheet can be activated by clicking on worksheet tab.
                        Worksheet Tab Scrolling Buttons: These are arranged on the left side of the horizontal
                        scroll bar. These are used to display the worksheet tabs which are invisible. The tab is clicked
                        to make a worksheet active.

                        Workbook: A workbook is a collection of different worksheets. By default, a workbook contains
                        only one worksheet—Sheet 1. The number of worksheets can be increased or decreased as
                        per the requirement.

                           TYPES OF DATA

                     To begin working with a Calc, the user has to feed data. Data can be classified into numeric, text,
                     date/time and formula.
                     Text Data (Label)

                     Text data are the data which are textual in nature. It refers to the data which is a combination of
                     alphabets, spaces, digits and/or other characters. If number are to be inserted as text, they are
                     mentioned within double quotes “  ”. By default, text data are aligned towards the left side of the
                     cell and are generally not meant for calculation.
                     Numeric Data (Values)

                     Numeric data consist of digits (0–9), Exponential (e), decimal (.) and numeric operators like +, -, /,
                     *, %, $. Numeric data or values are aligned towards the right side in a cell. Numeric data are the
                     operands on which the formula is applied to perform arithmetic calculations. Operands refer to
                     data on which the formula is applied. For example, 5+8, 5 and 8 are operands and + is the operator.
                     Date and Time

                     In  LibreOffice  Calc  displays  date  as  sequential  numbers  known  as  Serial  Values.  The  time  is
                     displayed as a fractional part. Date and Time are values and therefore can be added or subtracted

                     and can be included for other calculations. By default they are aligned towards the right side of
                     the cell.

                                                                                                    LibreOffice Calc     57

| 54 55 56 57 58 59 60 61 62 63 64 |