Available Answers

1. 1.

   Fill in the blanks with the correct words.

   Category, Pie, Two, Chart, Scatter

   1. A _____________ is a pictorial representation of data.
   2. A ____________ chart plots each data points with a marker.
   3. A _____________ chart is used to plot data for a single data series.
   4. The x-axis is also known as the ____________ axis.
   5. A 2-D graph has ____________ axes.
2. 2.

   Write T for the true statement and F for the false one. Correct the false statement(s).

   1. Excel supports only two types of charts.
   2. The two walls and the floor make up the plot area in a 3-D chart.
   3. The Charts group is available on the INSERT tab.
   4. You cannot change the size of a chart.
   5. The commands for formatting text and numbers in a chart are available on the FORMAT tab.
3. 3.

   Choose the correct option.

   1. Which of the following chart types compares trends in data at equal intervals?
      1. Line chart
      2. Column chart
      3. Pie chart
      4. None of these
   2. Which of the following chart shows the relationship of parts to the whole?
      1. Pie
      2. Doughnut
      3. column
      4. None of these
   3. The vertical y-axis is also known as the ___________ axis.
      1. Category
      2. Data
      3. Value
      4. None of these
   4. A ___________ identifies the data series.
      1. Legend
      2. Axis title
      3. Gridlines
      4. None of these
   5. In a 3-D chart, the xy plane is known as the
      1. Wall
      2. Axis
      3. Floor
      4. None of these
4. 4.

   What is the importance of charts in Excel?

5. 5.

   Name the tabs that appear when a chart is selected.

6. 6.

   What is a sparkline?