Page 186 - CA_165_V2.0_C9_Flipbook
P. 186

Numeric Data

                  Numeric Data consists of digits (0–9), exponential(^), decimal (.) and numeric operators (+,-,/,*,%,$).
                  Numeric data or values are aligned towards the right side in a cell. The numbers or values on which
                  formulae are applied to perform mathematical operations are called OPERANDS.

                  Alphanumeric or Text Data

                  Alphanumeric data are the data which are textual in nature. It refers to the data which is a combination
                  of alphabet, spaces, digits and/or other characters. In Calc, alphanumeric data are aligned (by default)
                  towards the left side of the cell and are generally not meant for calculation.

                  Date and Time
                  Calc displays date as sequential numbers known as Serial Values. Date and Time are values and therefore
                  can be added or subtracted and can be included for other calculations. They are aligned (by default)
                  towards the right side of the cell.

                  Formula

                  A formula is an expression which helps to perform arithmetical calculation and also executes non-
                  arithmetical tasks. It consists of the operands and the operators which operate upon the data. A formula
                  always starts with an ‘=’ sign.

                    CREATING A SPREADSHEET

                  To work in Calc, the user needs to know how to work with Spreadsheet. Calc opens with a new
                  Spreadsheet named Untitled1 as the default spreadsheet where the user can begin to work.
                  A user can also create a new spreadsheet using the following steps:

                  Step 1:   Click on the File menu from Menu bar.
                  Step 2:   Select the New option. A drop-down menu appears.

                  Step 3:   Click on Spreadsheet.
                            OR

                            Click on the New button from the Standard Toolbar. A new spreadsheet named Untitled 1
                            appears on the screen.


                                  1
                                                               3
                                  2





















                   184   Touchpad Computer Applications (Ver. 2.0)-IX
   181   182   183   184   185   186   187   188   189   190   191