IT Planet Class 7 Computer Chapter 4 Solution – Charts In MS-Excel
IT Planet Class 7 Solution: IT Planet Class 7 Computer Chapter 4 Charts In MS-Excel all Question Answer Solution by Expert Computer Teacher. Here Students can here all Questions Accurate Answers of Chapter Charts In MS-Excel Solution.
Q1) Tick ( √ ) the correct answer :-
a) The pictorial representation of data is called a
Ans: ii) Chart
b) The type of chart that shows the contribution of each value to a total value
Ans: i) Pie chart
c) The central area within a chart area where actual chart is displayed is known as
Ans: iii) Plot Area
d) A topographic map is the example of this type of chart.
iii) 3D surface
e) Text at the top of the chart is called
Ans: ii) Chart title
Q2) Write ‘T’ for True and ‘F’ for False statements :-
a) Stock chart is ideal for tracking the stock market activity. T
b) Area chart shows the correlation between the two value sets. F
c) Data series is a caption which identifies the category of axis. T
d) Charts cannot be resized or moved. F
e) Chart style is used to change the appearance of the chart. T
Q3) Fill in the blanks :-
a) Chart are made up of a variety of elements, also called data objects
b) A radar chart displays data in concentric irregular circles.
c) Pie chart has the shape of round pies cut into pieces or slices.
d) Legend tells what each data series in your chart represents.
e) Sparklines are tiny, word-sized charts that can appear in a cell.
Q4) Match the following :-
Q5) Answer the following questions :-
a) Solution:
Excel provides the facility of chart that is used for showing the data into the
pictorial form. One can select any of the chart from the various types of charts and its sub types available in Excel and represent the data in the pictorial form. With the help of charts its much easier to compare, analyze, evaluate the worksheet and take a quick decision. After inserting charts in your worksheet, your worksheet will look much descent and attractive. Once you make a click on Insert tab, different types of charts will be available like column line, pie, bar, are ,scatter etc
Usefulness of Charts in Excel
i) By making use of chart in Excel, it is much easier for one to understand.
ii) Important data and information can be presented in an attractive, beautifully way.
b) Solution:
Charts contains various elements which are :-
i) X- axis :- It is also known as category axis and is the horizontal axis in the chart.
ii) Y- axis :- It is also known as value axis and is the vertical axis in the chart.
iii) Data series :- The chart is taken/ derived from this/ such data series (group of data)
iv) Chart Area :- It is the place where all the chart components/ parts are enclosed/
available.
v) Plot area :- The central area within a chart area where actual chart is displayed.
vi) Chart Title :- It is at the very top of the chart and helps one to understand the chart
clearly with what the chart states/says/shows.
vii) Axis Title :- The titles are given to the two axis i.e is x – axis and y – axis in the chart.
viii) Gridlines :- These are the vertical and horizontal lines which are inserted a the plot
area of the chart that helps one to understand and read the chart.
ix) Legends :- Legend are useful in identifying the different plotted data series on the
chart. Legends can of different colour, pattern etc which can be easily identified by
the user. It is at the right side of the plot area.
x) Data Labels :- It is a text or label which gives the information about data points.
c) Solution:
There are different types of charts which are :-
i) Column Chart :– The data in this type of chart is been changed after a period
of some time and helps in comparing in various items. In column chart, the
categories are been arranged in horizontal axis and values with the vertical axis.
ii) Bar Chart :- This chart is displayed in the table or column form. In this chart, it is also shown that after some period of time, the data is changed or is been compared with some of the specific individual items
iii) Line Chart :- In this type of chart, there is continuous flow of data is shown
over a time and is setted against the common scale and are therefore ideal for
showing trends in data equal intervals. In this chart, the category data is shown
on the horizontal axis where as all the value data is to be shown on the vertical
axis.
iv) Area Chart :- In this type of chart magnitude of change over time is shown. It also shows the relationship of parts to a whole by displaying the sum of a plotted value.
v) Pie Chart :- This chart type is round/circle in shape which is being divided into
pieces of slices. The type of chart that shows the contribution of each value to a
total value (represented by overall pie). In one data series in this chart type the
size of things are been compared. In the pie chart, the data points is displayed as
the percentage of the whole pie.
vi) Dough nut :- This type of chart includes more than one data series. This chart
shape is like ring and each ring in the chart shows/displays different data series.
It shows the relationship/ link between the part and the whole.
vii) Scatter Chart :- This chart (Scatter chart) is little bit same as the line chart. In
the scatter chart the data is displayed by the lines scribbled where in the line
chart the data is displayed with the help of connected lines.
viii) Radar Chart :- In this type of chart the data is plotted in irregular concentric
circles. The data series which are arisen from the centre point have their own
values. All the values in the same series are connected with the lines.
ix) 3 D Surface chart :– It shows the data in three dimensional (3 D)
manner/view. For ex : – A topographic amp
x) Stock Chart :- This type of chart is used for tracking or keeping an eye on the
activities of stock market.
d) Solution:
i) Column :- The data in this type of chart is been changed after a period of some time
and helps in comparing in various items. In column chart, the categories are been
arranged in horizontal axis and values with the vertical axis.
ii) Pie :- As per the information/data provided, Pie chart splits/divides the chart/shows
the size of the items. It is displayed as point as the whole pie charts percentage. For
the easy identification, it can be of different colour or pattern.
iii) Area :- In this type of chart magnitude of change over time is shown. It also shows
the relationship of parts to a whole by displaying the sum of a plotted value.
iv) Stock :- This type of chart is used for tracking or keeping an eye on the activities of
stock market.
e) Solution:
These are small t, tiny- sized word chart that appears in the cell. There are three
types of Sparklines Charts in Excel like, Lines, Columns, Win/Loss. Its very easier for one to create the Sparklines chart.
Q6) Application based questions :-
Solution:
I would suggest Amar to make use of Column chart or Bar chart, if wants to show the
results in each cell.