Page 268 - open office
P. 268

Errors                                             Reasons


                              Occurs when the cell contains a number, date 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.

                   A UE!      Occurs when a wrong type of argument or operand is used.

                   AME        Occurs when  Calc  does not recognize text in a formula.

                   UM!        Occurs when there is a problem with a number in a formula or function.

                  REF!        Occurs when a cell reference is not valid.

                  DI / !      Occurs when a formula is divided by zero.




                 Recap Zone


                  A spreadsheet package is an application software that does analysis, calculations, comparisons and
                   displays information in the required format and in charts and graphs.
                  A worksheet consists of rows and columns.
                  Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position.
                  Columns are the vertical set of rectangular boxes that are placed adjacent to each other.

                  A rectangular box formed by the intersection of a row and column is called a cell.
                  The active cell in a worksheet is known as the Cell Pointer.
                   umeric data consists of digits ( – ),  e  (Exponential), decimal (.) and numeric operators like  , -, /,  ,
                    ,  .  umeric data or values are aligned towards the right side in a cell.

                  A formula is an expression  that  helps to perform arithmetical calculations and  also executes
                   non-arithmetical tasks.
                  A group of cells is known as a cell range.
                  Each cell in the worksheet has a unique address that is formed by the intersection of its column and
                   row say   A1  .

                  Navigation is a feature in Calc by which the cursor can be placed anywhere on a sheet directly.
                  An operator is a symbol that performs certain mathematical or logical operations.
                  Functions are in-built formula in ‘Calc’ that can be used to perform arithmetical and non-arithmetical
                   task.

                    ame  is the name of the function that signifies the nature of operation.
                   Argument  specifies the values or the range of cells on which the specific operation is being applied
                   and is always enclosed within the opening and closing parenthesis.












               26       Touchpad Information Technology-IX
   263   264   265   266   267   268   269   270   271   272   273