Charts in Excel

Fill in the blanks

Question 1

F11 function key is used to insert a chart instantly in a worksheet.

Question 2

The mini charts that fit into a single worksheet cell to provide the visual representation of the data are known as Sparklines

Question 3

Legend depicts the colours, patterns, and symbols assigned to the data series.

Question 4

Radar chart looks similar to a spider net.

Question 5

Chart Title describes the aim and contents of the chart.

State True or False

Question 1

A chart is a textual representation of data in a worksheet.
False

Question 2

Area chart displays data in the form of long rectangular rods also called bars.
False

Question 3

Line chart is in the form of lines and is used to illustrate trends in data at equal intervals.
True

Question 4

Scatter chart is the default chart type in Excel.
False

Question 5

Stock chart has been designed specifically for plotting data related to stocks and shares.
True

Application Based Questions

Question 1

Ritu is a student of class VII. Her geography teacher has asked her to prepare a chart on the population of four Metro cities of India. Suggest her the chart type that suits her project.

As Ritu needs to show only one data series which is the population of four Metro cities and as the number of cities is small (only 4) so a Pie chart will be best suited for her project.

Question 2

Tripti has created a chart. She wants to improve the appearance of her chart by changing the background colour of its Plot area. Which option will you suggest her to perform this task?

Tripti can use the Format Plot Area option that comes on right-clicking the plot area.

Multiple Choice Questions

Question 1

What type of chart is used to emphasize the magnitude of change overtime?

1. Pie
2. Area ✓
3. Bar

Question 2

.......... chart is designed specifically for plotting data values related to stocks and shares.

1. Pie
2. Area
3. Stock ✓

Question 3

What is the other name for the horizontal axis of a chart?

1. Y-axis
2. Value axis
3. Category axis ✓

Question 4

Which type of chart is used for representing huge amount of data?

1. Line ✓
2. Bar
3. Scatter

Question 5

What is the other name for XY chart?

1. Area
2. Bar
3. Scatter ✓

Question 1

What is a Chart?

A Chart is a graphical representation of data in a worksheet. It helps to provide a better understanding of large quantities of data. Charts make it easier to draw comparisons and see growth and relationship among the values and trends in data.

Question 2

How is a Column chart different from a Bar chart?

In Column chart, categories are organized horizontally and values vertically to emphasize the magnitude of change over a period of time. In Bar chart, categories are represented on the vertical axis and values are represented on the horizontal axis.

Question 3

Explain the different components of a chart.

The different components of a chart are:

1. Chart Area — Chart area includes all the area and objects in the chart.
2. Category Axis — Category axis or X-axis is the horizontal axis of a chart.
3. Value Axis — Value axis or Y-axis is the vertical axis used to plot the values. It is located at the left side.
4. Data Series — Data series are the bars, slices or other elements that show the data values. If there are multiple data series in the chart, each will have a different colour or style.
5. Category Name — Category names are the labels, which are displayed on the X and Y-axis.
6. Plot Area — Plot area is a window within the Chart area. It contains the actual chart itself, and includes plotted data, data series, category, and value axis.
7. Legend — It depicts the colours, patterns or symbols assigned to the data series. It helps to differentiate the data.
8. Chart Title — It describes the aim and contents of the chart.
9. Gridlines — These can either be Horizontal or Vertical lines depending on the selected chart type. They extend across the plot area of the chart. Gridlines make it easier to read and understand the values.

Question 4

What is a Pie chart? Describe its features.

Pie chart displays data in the form of a circle that is divided into a series of segments. These segments show the relative size of each item in the chart. It always shows only one data series and is useful when you want to emphasize on a significant element. This chart type works best with smaller number of values.

Question 5

Differentiate between Category Axis and Value Axis of a chart.

Category axis or X-axis is the horizontal axis of a chart whereas Value axis or Y-axis is the vertical axis used to plot the values. It is located at the left side.

Question 6

Explain the process of resizing a chart.