Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 28 - ClickGPT V4.0 C-5
P. 28

    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.

                     26     Premium Edition-V

| 23 24 25 26 27 28 29 30 31 32 33 |