Page 38 - Trackpad_V4.0_c6_Flpbook
P. 38

Release the mouse button on the cell up to which you want to select the range.

              Naming a Cell Range

              Excel allows us to assign a name to a cell range. This name can be used in place of the cell address in
              formulas. Perform the following steps to assign a name to a cell range:

                                                                                        Click on the  Define   3

                    2   Click on the                                                    Name button.
                        Formulas tab.

                                                                                        Select the range of
                                                                                        cells to which you      1
                                                                                        want to assign a name.





                 4
                     Type the name.






                    5   Click on the
                        OK button.


              Now, we can use this name in place of the cell address in formulas.


              USING CHARTS


              A chart is an effective way to display data in pictorial form. It makes it easier to draw comparisons and
              analyse the growth, relationships and trends among the values in a table. Excel provides a variety of
              different chart formats such as Bar, Column, Pie, Line, Area, Doughnut, Scatter, Surface and Radar.

              Components of a Chart

                  Chart Title: It describes the main aim and content of the chart.
                  X-axis: It is the horizontal axis of the chart. It is also called the category axis.
                  Y-axis: It is the vertical axis of the chart. It is also called the value axis.

                  Plot Area: It is the rectangular area bounded by the two axes. It contains the actual chart and includes
                 the plotted data, data series, category and value axis.

                  Data Series: It is related to the set of values. The bars or slices represent the data values.
                  Data Labels: These include data values, category name, series name, legend keys and values from
                 cells.
                  Gridlines: These can be either horizontal or vertical lines depending on the selected chart type. It
                 makes it easier to read and understand the values.










                 36     Premium Edition-VI
   33   34   35   36   37   38   39   40   41   42   43