Charts in Excel 2013
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 State whether True or False. Correct the False statements.
1. A bar chart is a column chart drawn sideways. (True)
2. A doughnut chart represents only one data series. (False)
(A pie chart represents only 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 dataset 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 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
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 Table: Helps to understand what information the chart shows.
e. Axis Title: Title given to an axis.
f. Chart Area: Area within which all chart components are placed.
g. Plot Area: Rectangular area bounded by two axes.
h. Legend: It identifies the data series.
i. Gridlines: Makes it easier to identify the value of data points.
j. Data Label: Gives additional information about a data point.
2. Write the steps to change the chart type.
DESIGN tab → Type group → Change Chart Type button
3. Explain the stock chart using an example.
A stock chart helps stock companies to analyze the fluctuation in stock prices.
4. List the steps to give light-pink background to a chart.
FORMAT tab → Shape Styles group → Shape Fill → Select light pink color.
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.
INSERT tab → Charts group → Recommended Charts
Insert dialog box appears.
All Charts tab → Combo.
Comments
Post a Comment
This site is all about helping you kids study smart because for Gen Z, studying "hard" is not enough. If you feel there is any way I could improve my posts or if you have any random suggestion that might help make this more kid friendly, please don't hesitate to drop in a comment!
Be sure to check back for my response if you've asked me a question or requested a clarification through the comment section because I do make every effort to reply to your comments here.