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

COMMON ERRORS

                  Sometimes when we use wrong type of data, operand or operator in a formula, then error message gets
                  displayed. Given below is the list of errors which commonly occur in ‘Calc’.

                         Errors                                           Reasons

                                        Occurs when the cell contains a number, data or time that is wider than the cell
                    ####                width or when the cell contains a date and/or time formula that produces a
                                        negative result.
                    #VALUE              Occurs when a wrong type of argument or operand is used.


                    #NAME               Occurs when ‘Calc’ does not recognize text in a formula.

                    #NUM                Occurs when there is a problem with a number in a formula or function.

                    #REF!               Occurs when a cell reference is not valid.

                    #DIV/0!             Occurs when a formula is divided by zero.

                    SORTING

                  Sorting refers to the process of arranging data in ascending or descending order based on a certain criteria.

                  To Sort data:
                  Step 1:   Select the column/row whose data is to be sorted.

                  Step 2:   Click on ‘Sort’ option from ‘Data’ menu.





                                 2


                                                                                                      1












                  Step 3:   ‘Sort’ dialog box appears on the        4                                               5
                            screen.

                  Step 4:   Select the column to be sorted.

                  Step 5:     Click on Ascending/Descending check
                            boxes.

                  Step 6:     Click on ‘OK’ button. The table will be
                            sorted based on the specified field.





                   206    Touchpad Computer Applications-IX
   203   204   205   206   207   208   209   210   211   212   213