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