Chapter - 4
Charts in MS Excel 2007
1)
|
What happens to a chart when you
change the data or text in a worksheet?
|
Any changes in the worksheet will automatically
update the chart.
|
|
2)
|
How do you change the chart type?
|
a)
Double click the chart. The
Design tab opens
b)
Click the Change Chart Type in the type group
c)
Choose the new Chart Type and its Subtype
|
|
3)
|
Mention any three subtypes of Pie
charts.
|
Pie-in 2 D
Pie-in 3 D
Exploded Pie
|
|
4)
|
How do you resize a chart?
|
To resize a chart proportionally, drag the corner
handle on the chart diagonally.
|
|
5)
|
What is a chart?
|
A picture showing numeric data is called a chart or graph. Charts are
more attractive and appealing than simple representation of data.
|
|
6)
|
How do you delete data from a
chart?
|
By deleting the data from the related worksheet, we can delete the
data from a chart too.
|
|
7)
|
How do you create a chart in Excel?
|
a)
Select the cells within the table.
b)
Click the Insert tab on the Ribbon.
c)
Select the type of chart you want from the Charts group.
d)
Select the chart subtype from the drop down list.
|
|
8)
|
Explain the following charts
|
a)
Line Chart
A Line chart shows trends
in data at equal intervals. It shows
data in different styles of lines varying at equal intervals.
b)
Pie Chart
A pie chart shows one data
series in the form of the comparative size of things that make up the data
series to the sum of the items.
c)
Column chart
A column chart shows data
changes over a period of time or illustrates comparisons among items.
|
|
9)
|
Name the different tabs that appear when charts get
created.
|
a)
Design Tab
b)
Layout Tab
c)
Format Tab
|
|
10)
|
Name the locations where charts can be created?
|
Charts can
be created on the current worksheet, as an object in separate sheet or in the
current workbook.
|
