Charts in MS Excel Class 7 MCQ: CBSE Board Class 7 Computer MCQ Questions and Answers with elaborate explanation. Students get here all Important MCQ on Charts in MS Excel Class 7.
Charts in MS Excel Class 7 MCQ with Answers and Explanations:
(1) The pictorial form of representing the data in Excel
(a) Themes b) Charts c) Clip Arts d) Pictures
Explanation :- MS-Excel helps the user in providing the facility of Charts in representing the data into the pictorial form for the better understanding of other person. By making use of charts in the Excel, it helps the user to easily analyse the numerical data in the worksheet and quickly take the correct decision. Column chart, Bar chart, Line chart, Area chart, Doughnut chart, Scatter chart, Radar chart, 3D surface chart , stock chart etc are some types of chart.
(2) It is the base of any chart in the worksheet data that is used to create.
(a) Pictures b) Data series c) Themes d) None of these
Explanation :- In the worksheet data, data series is the base of any chart, that is used to create. It is the group related cells with the data such as one row or column containing data in the worksheet or it is a group of data from which chart is derived/taken.
(3) The type of chart that displays the data, that changes over a period of time and compares various items.
(a) Column Chart b) Bar chart c) Area chart d) Doughnut chart
Explanation :-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.
(4) This is one type of chart that shows the data in tabular form or in column pattern.
(a) Area Chart b) Doughnut Chart c) Column Chart d) Bar chart
Explanation :-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.
(5) This chart shows the magnitude change over a period of time.
(a) Column Chart b) Bar chart c) Area chart d) Doughnut chart
Explanation :-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.
(6) In this chart type, the category data is shown on horizontal axis and the value data on the vertical axis.
(a) Scatter Chart b) Doughnut chart c) Area chart d) Line chart
Explanation :-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.
(7) This chart is round in shape and is been cutted into slices.
(a) Doughnut chart b) Pie-chart c) Scatter chart d) Radar chart
Explanation :-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.
(8) In this type of chart, the data is plotted into the concentric circles that is irregular.
(a) Radar Chart b) Stock chart c) Scatter chart d) Doughnut chart
Explanation :-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.
(9) There are more than one data series in this type of chart.
(a) Radar Chart b) Stock chart c) Scatter chart d) Doughnut chart
Explanation :-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.
(10) The chart type helps in tracking the stock market activity
(a) Radar Chart b) Stock chart c) Scatter chart d) Doughnut chart
Explanation :-This type of chart is used for tracking or keeping an eye on the activities of stock market.
(11) A topographic map is an example of
(a) Doughnut chart b) 3D chart c) Scatter chart d) Radar chart
Explanation :-It shows the data in three dimensional (3 D) manner/view. For ex : – A topographic map
(12) This chart is displayed with the scribble in line
(a) Stock chart b) Scatter chart c) Radar Chart d) 3D chart
Explanation :-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.
(13) This falls to the right side of the plot area which identifies each data of the series.
(a) Gridlines b) Legend c) Data labels d) None of these
Explanation :-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.
(14) This are the horizontal and vertical lineson the plot area.
(a) Gridlines b) Legend c) Data labels d) None of these
Explanation :-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.
(15) It is the title given to two axis
(a) Axis name b) Axis title c) Axis naming word d) All of these
Explanation :-The titles are given to the two axis i.e is x – axis and y – axis in the chart. X axis is known as category axis and is the horizontal axis in the chart whereas Y axis is also known as value axis and is the vertical axis in the chart.