Page 73 - 2622_Delhi Police Public School_C-6

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.

Charts, Formulas & Functions in Excel 71