Page 38 - C_GPT _V4 _class_6
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 CodeGPT (Ver. 4.0)-VI

