CLASS VIII
CHAPTER 3
Microsoft Excel 2010 Charts
[Link] the correct option:
[Link] chart displays column of various lengths
horizontally?
Ans) a- Bar Chart
[Link] chart displays data in the form of vertical
bars?
Ans) b- Column Chart
[Link] chart represents the correlation between two
value sets?
Ans) a- scatter chart
[Link] chart shows trends in data at equal intervals?
Ans) d-Line chart
[Link] True or False:
[Link] chart represents the data in the form of round
pies cut into pieces or slices. (True)
[Link] chart displays columns of bar lengths
horizontally. (True)
[Link] chart helps in tracking the stock market
activity.(False)
[Link] chart represents the interaction of three sets
of data.(True)
[Link] we insert a chart, a set of chart tool organized
into three tabs appear on the Ribbon. (True)
6. We cannot remove chart elements that we do not want
to display. (False)
[Link] in the blanks:
[Link] default, there is no title for a new built chart in
Excel.
[Link] default chart type in Excel is Column chart.
[Link] create a chart click on the Insert tab.
[Link] tab helps us to change chart type.
[Link]+F2 are the keyboard shortcut for displaying the
print preview.
[Link] short answer type questions:
[Link] the type of chart which represents the data in
the form of round pies.
Ans) Pie chart
[Link] type of chart shows trends in data at equal
intervals?
Ans) Line chart
[Link] function key is used to insert a chart?
Ans) F11
[Link] many tabs are displayed on the Ribbon when a new
chart is created? Write their names.
Ans) Three- Design, Layout, Format
[Link] do we need to resize a chart?
Ans)When there is less or more space on the worksheet
[Link] tab should be used to insert the chart?
Ans) Insert
[Link] group contains ‘Change Chart type’ option?
Ans) Type group in Design Tab
[Link] should be done to make a hard copy of chart in
excel?
Ans) Take a printout of chart
[Link] tab contains protect sheet icon?
Ans) Review tab
[Link] type questions:
[Link] is a chart?
Ans) Chart is a pictorial representation of large amount
of data in a worksheet.
[Link] the advantages of chart.
Ans) Advantages of charts:
[Link] present the data and information in an
attractive manner.
[Link] are easier to understand and compare.
[Link] provide more accurate analysis of
information.
[Link] is the difference between a column chart and bar
chart?
Ans) Column chart displays data in the form of vertical
bars whereas Bar chart display data in the form of
horizontal bars.
[Link] is chart title?
Ans) It is a heading that appears above the main chart.
[Link] the screen elements of a chart.
Ans) Chart area, Plot area, Data Points, Legend, Chart
and axis title, Data Label, horizontal (category) and
vertical (Value) axis
[Link] answer type questions:
[Link] the following chart types in Microsoft Excel
2010 .
A)Area chart: This type of chart displays graphically
quantitative data. We compare two or more quantities
with area chart.
B)Doughnut chart: This type of chart compares multiple
series of data.
C)Stock chart: This type of chart helps in tracking
stock market activity.
D)Bubble Chart: This type of chart is used to show 3-D
data in a flat 2-D chart. In this chart the data is
represented in bubbles.
[Link] the following screen elements of a chart:
A)Chart area:This the area surrounding the chart.
B)Plot area: This is the area in which we plot our
data.
C)Data Points: It is a single value located in a
worksheet cell that is plotted in a chart.
D)Legend: It decribes colour, patterns and symbols
assigned to data series.
[Link] steps to create charts in Excel.
i) Select the data which we want to represent in
chart.
ii) Click on insert tab.
iii) Click on the chart type we want to use under
charts group.
iv) A drop down list of charts will appear.
v) Click on the chart style we want to use.
[Link] steps to format chart.
i) Right click on any area of the chart eg. Chart
area.
ii) Click on Format chart area.
iii) Select the desired option.
iv) Click close to see the effect.
[Link] steps to print a chart.
i) Select the Chart to be printed.
ii) Click on the File tab.
iii) Click on the Print option.
iv) Give the number of copies, Select the printer.
v) Click on Print button to start printing.