Page 174 - CA 165 ver 1.0 Class 9
P. 174

Numeric Data

                  ‘Numeric  Data’  consists  of  digits  (0–9),  ‘e’  (Exponential),  decimal  (.)  and  numeric  operators  like  +,-
                  ,/,*,%,$.  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. Alphanumeric data is mentioned within double
                  quotes “   ”. 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. The time is displayed as fractional
                  part (it is considered as a part of a day). 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 WORKBOOK

                  To work in ‘Calc’, the user needs to know how to work with a Workbook. ‘Calc’ opens with a new
                  workbook named ‘Untitled 1’ as the default workbook where the user can begin to work.
                  A user can also create a new workbook using the following steps:

                  Step 1:   Click on the ‘File’ menu and click on the ‘New’ option.
                  Step 2:   A sub-menu appears, click on ‘Spreadsheet’.

                            OR Click on the ‘New’ button from the Standard Toolbar.










                                Active Cell












                  A new workbook displaying the active worksheet, ‘Sheet1’ appears on the screen with cell A1 as the
                  active cell.


                   172    Touchpad Computer Applications-IX
   169   170   171   172   173   174   175   176   177   178   179