Available Answers

1. 1.

   Fill in the blanks.

   1. When you enter data in a Microsoft Office _______________ worksheet, you create a table of important data.
   2. To create a chart in Excel, you start by entering the numeric data for the chart on a _______________.
   3. Different kinds of charts represent data trends with the help of _______________ figures.
   4. Click the chart type, and then click a chart _______________ from the drop menu that will appear.
   5. Click on the _______________ area to add a data label to all data points of all data series.
2. 2.

   Write True or False.

   1. Excel 2007 has only one kind of chart.
   2. Charts can be made using 2D and 3D graphics.
   3. The chart area is a part of the chart and all its elements.
   4. Unwanted chart elements can be removed from the chart.
   5. You can move a chart to any location on a worksheet.
3. 3.

   Multiple Choice Questions (MCQs).

   1. Trends in a large collection or table of data is shown by creating a _______________ which summarises data visually.
      1. chart
      2. field
      3. worksheet
   2. The _______________ points are individual values plotted in a chart represented by bars, columns, lines, or pies.
      1. main
      2. cross
      3. data
   3. To move a chart, on the _______________ tab, in the Location group, click Move Chart.
      1. Design
      2. Layout
      3. Labels
   4. To change the name of a chart, on the _______________ tab, in the Properties group, click the Chart Name text box.
      1. Layout
      2. Insert
      3. Design
   5. When you create a chart, the _______________ appears, but you can hide the legend.
      1. pop-up
      2. design
      3. legend
4. 4.

   What is the best way to show trends in a table of data?

5. 5.

   What steps do you follow to create a chart from data in a worksheet?

6. 6.

   Name any five commonly used charts.