Page 21 - TP-Play_V-2.0_Book-7
P. 21
3. Which of the following charts is used to display the quantitative magnitude of the data graphically?
a. Bar chart b. Area chart
c. Column chart d. Scatter Chart
4. Which one of these tabs contains the Change Chart Type command?
a. Design b. Layout
c. Format d. All of these
B. Fill in the blanks using the words given below.
legend, scatter, chart styles, design, column chart
1. The ............................... chart usually displays the data in the form of vertical bars.
2. ............................... is a key which shows the meanings of symbols and colours used in the chart.
3. ............................... charts also known as XY scatter plot charts.
4. The ............................... tab is used to change the design of a chart in Excel 2016.
5. Excel has some in-built ................................
C. Write ‘T’ for true and ‘F’ for false.
1. We cannot create Bar chart in Excel 2016. .....................
2. Excel does not provide any tool to improve the appearance of a chart. .....................
3. Plot area of a chart is the rectangular area bounded by the two axis. .....................
4. The bar chart displays the data in the form of long rectangular rods also .....................
called bars.
D. Short answer type questions:
1. What is chart?
.....................................................................................................................................................................................................
2. Define data series.
.....................................................................................................................................................................................................
3. What is area chart?
.....................................................................................................................................................................................................
Charts in Excel 21

