Page 34 - Code & Click - 7

Post-Processingost-Processing
P
 A Chart is a visual representation of data, in which data is represented by symbols such as
bars, lines or circles.

 Excel 2016 offers the following types of charts – Column, Line, Pie, Bar, Area, XY (Scatter),
Stock, Surface, Radar, Treemap, Sunburst, Histogram, Box & Whisker, Waterfall, Funnel, and
Combo.
 The different parts that make up a chart are referred to as chart elements
 The Charts group on the Insert tab provides options to insert a specific type of chart in a
worksheet.
 You can add or remove elements in a chart as desired.
 The overall arrangement of a chart’s elements is called its Layout.

 The overall appearance of the chart’s elements is called its Style.
 Sparklines are compact charts that summarize data within a cell in a worksheet.

Info Retention

A. Select the correct option for each of the following statements.

1. A chart that combines two or more chart types in a single chart is called a ______.
(a) Combo chart (b) Sparkline (c) Pie chart (d) Joint chart
2. The area bounded by the two axes in a chart is called ______.
(a) Axes Area (b) Chart Area (c) Plot Area (d) Joint area

3. The horizontal and vertical lines that determine the value represented by a data point in a
chart are called ______.
(a) Legends (b) Gridlines (c) Axes (d) Data Labels

4. The overall arrangement of elements in a chart is called its ______.
(a) layout (b) style (c) format (d) template

B. Fill in the blanks with the correct answer.
1. The _________ sparkline indicates whether a cell value is positive, negative, or zero.

2. _________ refers to the area within which all chart elements are placed.
3. A _________ uses different colours or symbols to identify different data series in a chart.

4. The _________ tab provides option to move the chart to a new location.

C. Write ‘T’ for True and ‘F’ for False statement.
1. You can move a chart within the same worksheet, to a new sheet or to another

worksheet. _______
2. Data labels display the values that are represented by the chart in a grid at the
bottom of the chart. _______

3. In a Scatter chart, both the horizontal and vertical axes represent numeric values. _______
4. A Radar chart represents data in the form of a spider web. _______

32