Charts in Excel 2013

Objective Type Questions

A. Fill in the blanks with the correct words.

  1. The y-axis is also known as the Value axis.
  2. The Legend identifies the data series.
  3. The Data Label provides additional information about a data point on a chart.
  4. The Radar chart plots data in concentric circles.
  5. The Pie chart is used to plot data for a single data series.

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

  1. A bar chart is a column chart drawn sideways. (TRUE)
  2. A doughnut chart represents only one data series. (FALSE) (A doughnut chart can contain more than one data series)
  3. A 3-D chart contains two walls and a floor. (TRUE)
  4. You cannot move a chart on the worksheet. (FALSE) (We can move a chart on the worksheet)
  5. If you are not sure which type of chart to create, click the Recommended Charts command. (TRUE)

C. Choose the correct option.

  1. Which of these options means the data set used for creating a chart?
    a. Legend
    b. Data table
    c. Chart area
    d. Chart tools
  2. Which of these is the rectangular area bounded by the two axes?
    a. Legend
    b. Data label
    c. Plot area
    d. Gridlines
  3. Which of these charts plots data for a single data series?
    a. Column chart
    b. Pie chart
    c. Scatter chart
    d. Bar chart
  4. Which of these shortcut buttons appear at the top-right corner of a chart?
    a. Chart Elements
    b. Chart Styles
    c. Chart Filters
    d. All of these
  5. Which of these gives a y-axis title to your chart?
    a. Chart Title
    b. Axis Title
    c. Primary Vertical
    d. Primary Horizontal

Descriptive Type Questions

D. Answer the following.

  1. Describe all the components of a chart.
    a. Data Table: Set of data values from which the chart is derived.
    b. X-Axis: Horizontal axis of the chart.
    c. Y-Axis: Vertical axis of the chart.
    d. Chart Title: Gives information about what the chart represents.
    e. Axis Title: The title given to an axis.
    f. Chart Area: Area within which all chart components are placed.
    g. Plot Area: Rectangular area bounded by the two axes.
    h. Legend: Identifies the data series.
    i. Gridlines: Lines that run across the plot area.
    j. Data Label: Provides additional information about a data point.
  2. Write the steps to change the chart type.
    Step 1: Click the Change Chart Type button in the Type group of DESIGN tab.
    (The Change Chart Type dialog box appears)
    Step 2: Select a new chart type and the desired layout.
    Step 3: Click OK.
    (The selected chart will appear)
  3. Explain the stock chart using an example.
    The stock chart helps investors, stock companies, and traders to analyze the fluctuation in stock prices.
Stock Chart Example.

4. List the steps to give light-pink background to a chart.
Step 1: Select the chart as a whole by clicking on it.
Step 2: Click Shape Fill option in the Shape Styles group of the FORMAT tab.
Step 3: Select light-pink color from the color palette that appears.
(This will set the background color for the chart as light-pink)

5. What is a combo chart? How will you create a combo chart?
A combo chart is a single chart that plots the series using different chart types. Following are the steps to create a combo chart:
Step 1: Select the data range.
Step 2: Click Recommended Charts in the Charts group of the INSERT tab.
(The Insert Chart dialog box appears)
Step 3: Click the All Charts tab.
Step 4: Select Combo in the left pane.
Step 5: Select the required charts for different Series.
Step 6: Click OK.

Leave a Reply