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.

Extra Questions:

  1. A chart is a graphical representation of data.
  2. 3-D charts have a base area, known as the floor and vertical areas, known as the walls.
  3. The line chart compares trends in data at equal intervals.
  4. In column chart, categories are organized horizontally and values vertically.
  5. The 3-D stacked column chart shows the relationships of parts to a whole.
  6. The doughnut chart shows the relationships of parts to a whole and it can contain more than one data series.
  7. In area chart, the data point markers are not displayed, and the area beneath the lines is filled with color.
  8. The XY scatter chart plots each data point with a marker.
  9. In bubble chart, the data points are replaced with bubbles.
  10. A topographic map is an example of 3-D surface chart.
  11. You can use the Chart Formatting buttons to quickly add chart elements, change the chart style, and filter the chart data.
  12. A combination chart is a single chart that plots the series using different chart types.
  13. A sparkline is a miniature chart embedded in a single cell of the worksheet.
  14. The Win/Loss sparkline indicates whether a cell value is positive, negative, or zero.
  15. Major Gridlines are the gridlines that are arranged at large intervals.
  16. Minor Gridlines are the gridlines that are arranged at smaller intervals.
  17. Bar charts have the category axis vertical.
  18. In Excel 2013, there is no limit on the number of data points in a data series. (True)
  19. A combination chart may include a second value axis. (True)
  20. Name the three Chart Formatting buttons.
    The three Chart Formatting buttons are: Chart Elements, Chart Styles, Chart Filters.
  21. Name the three types of sparklines.
    The three types of sparklines are line, column, and win/loss.