Objective Type Questions
A. Fill in the blanks with the correct words.
- The y-axis is also known as the Value axis.
- The Legend identifies the data series.
- The Data Label provides additional information about a data point on a chart.
- The Radar chart plots data in concentric circles.
- 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).
- A bar chart is a column chart drawn sideways. (TRUE)
- A doughnut chart represents only one data series. (FALSE) (A doughnut chart can contain more than one data series)
- A 3-D chart contains two walls and a floor. (TRUE)
- You cannot move a chart on the worksheet. (FALSE) (We can move a chart on the worksheet)
- If you are not sure which type of chart to create, click the Recommended Charts command. (TRUE)
C. Choose the correct option.
- Which of these options means the data set used for creating a chart?
b. Data table
c. Chart area
d. Chart tools
- Which of these is the rectangular area bounded by the two axes?
b. Data label
c. Plot area
- Which of these charts plots data for a single data series?
a. Column chart
b. Pie chart
c. Scatter chart
d. Bar chart
- 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
- 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.
- 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.
- 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)
- Explain the stock chart using an example.
The stock chart helps investors, stock companies, and traders to analyze the fluctuation in stock prices.
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.