Page 30 - iPlus_Ver_2.0_class_8
P. 30

i +  COMMON ERRORS

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


                             Errors                                           Reasons

                                                It 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                      It occurs when the wrong type of argument or operand is used.

                    #NAME                       It occurs when Excel does not recognize text in a formula.

                    #NUM                        It occurs when there is a problem with a number in a formula or function.
                    #REF!                       It occurs when a cell reference is not valid.

                    #DIV/0!                     It occurs when a formula applying division by zero is used.


                   i +  CHARTS IN EXCEL

                  A chart is a visual or graphical representation of data from a worksheet which is very useful for
                  instant analysis and decision making. There are various options related to charts that can be
                  used to display data in a graphical format. It makes it easier to draw comparisons and analyse
                  the growth, relationships, and trends among the values in a table.
                  Components of a Chart

                  •  Chart Title: It is the heading text that helps to identify the chart.

                  •  X-axis: It is the horizontal axis known as category axis.

                  •  Y-axis: It is the vertical axis and is known as value axis.
                     The X and Y axis divide the X-Y plane into four quadrants.

                  •  Plot Area: It is that area of the chart in which the data is plotted.
                     In a 2-D chart; axis bound the plot area whereas in 3-D charts, walls and floors bound the plot
                     area.

                           Gridlines                                                                Chart Title





                                                                                                    Plot Area



                                                                                                    Data Series
                              Y-axis
                              X-axis                                                                Data Labels
                                                                                                    Legend




                    28
                         iPlus (Ver. 2.0)-VIII
   25   26   27   28   29   30   31   32   33   34   35