microsoft excel 2010 charts

Ch-3

Microsoft Excel 2010 Charts

Class8

Short answer type questions: -

Q1. What is a chart?

Ans1. Charts a pictorial representation of large amount of data in a worksheet.

Q2. Write the advantages of a chart.

Ans2.    1) charts present data and information in an attractive manner.

            2) charts are easier to understand and compare.

Q3. What is the difference between a column chart and a bar chart?

Ans3. Column chart displays data in the form of vertical bars while bar chart displays data in the form of horizontal bars.

Q4. What is a chart title?

Ans4. It is the title given to the chart.

Q5. Name the screen elements of a chart.

Ans5. 1) chart area

2) plot area

3) data points

4) legend

5) chart and axis title

6) data label

Long answer type questions:-

Q1. Define the following chart types of Microsoft Excel 2010.

a)     Area chart

b)    Doughnut chart

c)     Stock chart

d)    Bubble chart

Ans1. 1) Area chart :- This displays quantitative data. It is used to compare two or more quantities.

2) Doughnut chart:- This compares multiple series of data.

3) Stock chart:-  This helps in tracking stock market activity.

4) Bubble chart:- This is used to show 3-D data in a flat 2-D chart.

Q2. Define the following screen elements of a chart.

a)     Chart area

b)    Plot area

c)     Data points

d)    Legend

Ans2. 1) Chart area:- this is the area surrounding the chart.

Plot area:- this is the area in which we plot our data

Data points:- it is a single value located in a worksheet cell.

Legend:- it describes colors, patterns and symbols assigned to data series.

Q3. Write the steps to create a chart in Excel.

Ans3. To create a chart: -

1)    Select the data

2)    Click on insert tab.

3)    Click on the chart type under charts group.

4)    Click the chart style we want to use.

5)    The chart will be displayed.

Q4. Write the steps to Format the chart.

Ans4. To format a chart: -

1)    Right click any area of the chart.

2)    Click on Format Chart Area.

3)    Select the desired option.

4)    Click close to see the effect.

Q5. Write the steps to print a chart.

Ans5.  To print a chart:-

1)    Select the chart to be printed

2)    Click on the file tab.

3)    Click on the print option.

4)    Give number of copies, select printer and click on print button.