Page 247 - open office
P. 247

DATA









                        UMERIC               A PHA- UMERIC                   DATE/TIME                 FORMU A



                 Numeric Data
                  umeric data consist of digits ( – ),  e  (Exponential), 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.

                 Alphanumeric or Text Data

                 Alphanumeric data is the data that is textual in nature. It refers to the data that is a combination of alphabets,
                 spaces, digits and/or other characters. Alphanumeric data is mentioned within double-quotes “   ”. In Calc,
                 alphanumeric data is aligned (by default) towards the left side of the cell and is generally not meant for
                 calculation.

                 Date and Time

                 ‘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.
                 They are aligned (by default) towards the right side of the cell.

                 Formula

                 A formula is an expression that helps to perform arithmetical calculation and also executes non-arithmetical
                 tasks. It consists of the operands and operators that operate on the data. Formula has to be expressed with
                 prefix     before the operator/data.
                   CREATING A WORKBOOK

                 To work in ‘Calc’, the user needs to know how to work with Workbook. ‘Calc’ opens with a new workbook
                 named  Untitled1  as the default workbook where the user can begin to work or create a new workbook. To
                 do so:
                 Step 1:  Click on the ‘File’ menu and select the option ‘New’.

                 Step 2:  A sub-menu appears. Click on ‘Spreadsheet’.
                          Or  Click on the   ew  button from the Standard Toolbar.

                 Step 3:  A new workbook named  Untitled 1  appears on the screen.













                                                                                     Working with Spreadsheet       24
   242   243   244   245   246   247   248   249   250   251   252