Foundation Of Information Technology Worksheet With Answers - People'S Public School, Bhopal - 2015/16
ADVERTISEMENT
1
2
3
4
5
6
7PEOPLE’S PUBLIC SCHOOL, BHOPAL
Worksheet (October) (2015-2016)
SUBJECT – Foundation of Information Technology
CLASS…VII
Chapter-4: Charts in MS Excel 2007
Worksheet-1
1.
Fill in the Blanks:
(a)
……………………….chart shows columns with a cylindrical shape.
(b)
A Picture showing data is called ………………………
(c)
Charts are easier to Understand and………………………
(d)
Chart Styles group is present in…………………………….tab of the Ribbon.
(e)
Information represent in charts is in a ……………………….manner.
2.
State True/False
(a)
A picture showing numeric data is called a chart or graph.
(b)
Other charts include Surface, Doughnut, Bubble and radar Charts.
(c)
A Bar Chart shows data changes over a period of time or illustrates comparisons
among items.
(d)
Chart Style group is present in layout tab.
(e)
3.
Give One Word:
(a)
Name the Shortcut key to print a worksheet.
(b)
A key automatically creates a chart for existing data.
(c)
Chart Shows comparisons among individual items.
4.
Multiple Choice Questions:
(a)
A……………………Chart Shows trends in data at equal intervals.
(a)Line
(b)Pie
(c)Bar
(b)
Pyramid Chart is present in………………………… option.
(a)column
(b)Bar
(c)none of these
(c)
………………………chart shows columns with a cylindrical shape.
(a)Column
(b)Pie
(c)Cylinder
(d)
Shortcut key to show print preview of a Chart graph.
(a)Ctrl+F2
(b)Ctrl+F4
(c)Ctrl+F11
(e)
A…………………………… Chart shows pairs of values in scatter format.
(a)Other
(b)Area
(c)Scatter
Worksheet-2
1.
Short Answer Questions:
(a)
What happens to a chart when you change data or text in a worksheet?
(b)
Mention any two subtypes of Pie charts.
(c)
How do you change a chart type?
(d)
How do you resize a chart?
2.
Long Answer Questions:
(a)
Explain the following chart:
(a)Line Chart
(b)Pie Chart
(c)Column Chart
(b)
How do you create a chart in MS Excel?
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education