CLASS - VII | CHAPTER-3 (Charts in Excel) (Worksheet)

CHAPTER-3

Chart in Excel

    Worksheets

Worksheet 1  Multiple Choice Question (MCQs).

1. Which Axis is also known as Category axis?

1. Y-axis

2. X-axis

3. Z-axis

4. Circular axis
   
   

2. Which charts are useful for showing data changes over a period of time or for illustrating comparisons among items?

1. Pie Chart

2. Area chart

3. Column Chart

4. Scatter chart

3. Which option from the drop down menu will first resize the chart and then as a title above the chart area?

1. None

2. Centered overlay title

3. Above Chart

4. Below Chart

4. Which chart show trend in data at equal intervals?

1. None

2. Line Chart

3. Pie Char

4. Column Chart

5. What is used to represent Data series ?

1. Chart Title

2. Legends

3. X-axis

4. Y-axis

Worksheet 2  Write (T) for True and (F) for False against the statements. 

1. Y-axis is also called the Category axis.  FALSE

2. A category axis become a time scale axis when the Axis Type is set is set to Data axis. TRUE

3. The Y-axis shows the values of the plotted Data points. TRUE

4. Legends are used to represent the Data series. TRUE

5. A Spark line is a large chart in a worksheet cell. FALSE

Worksheet 3  Select the suitable words and fill in the blanks.

Chart title     Line Pie X-axis Y-axis Column

1. __COLUMN______ charts are useful for showing data changes over a period of time or for illustrating comparisons among items.

2. A____LINE_______ chart shows trend in data at equal intervals.

3. A_____Pie______ chart shows the proportional size of items included in single data series.

4. The ____X-axis______is also called the Category axis.

5. The ____Y-axis________is also called the Value axis.

6. The ____Chart title_____give you an idea about the topic of chart.

Worksheet 4  Match the following:

Answer:

Column A	Column B
Charts                                    -->	Represents data graphically.
Data Series                          -->	Gives us an idea about of related values, like all data values in a row or a column of the data sheet.
Legends                             -->	A name for a group of related values, like all data value in a row or a column of the data sheet.
Line Chart                        -->	Shows a trend in data at equal intervals.
Pie Chart                           -->	Shows the proportional size of the items included in a single data series.
Bar Chart                         -->	The best chart types for comparing multiple sets of value.
Chart Title                         -->	Used to represent the data series.

Worksheet 4  Answer the following:

1. Explain about the various chart types.

Answer: Column Charts -  In column charts, categories are typically organized along the horizontal axis (x-axis) and value along the vertical axis (y-axis).

Line Charts -  A Line charts shows a trend in data at equal intervals. Line charts are useful for depicting the change in a value over a period of time.

Pie Charts -  A pie chart shows the proportional size of the items included in a single data series.

Bar Charts -  Bar Charts are very similar to Column charts, the only difference is that bars are horizontal.

2. Write about the axis of chart.

Answer: Y-axis -  The Y-axis shows the value of plotted Data points. This is also called the Value axis.

X-axis -  The X-axis generally shows the category of plotted Data points. This is also called the category axis. A category axis becomes a time scale axis when the Axis Type is set to Date or Time axis.

3. What are Data series and Legends in a chart?

Answer: Data Series -  The Data series is a group of related values, like all Data values in a Row or a Column of the Data sheet.

Legends -  Legends are used to represent the Data series. These Legends are associated with a pattern or colour, which is associated with the series and placed on the Chart.

4. What will happen if you change a value in the data from where you have created the charts?Answer:  chart is also change according to the change the values in the data.

5. What do you know about Spark lines?

Answer: A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a sparkline near its data for greatest impact.