Page 222 - CA_165_V2.0_C9_Flipbook
P. 222

COMMON ERRORS

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

                     Cell error                                         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.


                                   Occurs  when  a  function  name  is  typed  incorrectly,  a  named  range  is  undefined,
                    #NAME?
                                   quotation marks for text are misused, or an undefined constant or function is used.

                                   Occurs when there is an invalid numeric operation, such as performing calculations
                    #NUM!          on out-of-range numbers, taking the square root of a negative number, or dividing
                                   by zero. It can also happen if the result is too large or too small.

                                   The formula within the cell uses a reference that does not exist. Either a column
                    #REF!          or row description name could not be resolved, or the column, row, or sheet that
                                   contains a referenced cell is missing.
                    #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, follow these steps:
                  Step 1:   Select the column or range of data to be sorted.

                  Step 2:   Click the Data menu on the menu bar.
                  Step 3:   Select the Sort option from the drop-down menu. The Sort dialog box will appear.


                   220   Touchpad Computer Applications (Ver. 2.0)-IX
   217   218   219   220   221   222   223   224   225   226   227