Page 67 - ModularV1.1 _c6_flipbook
P. 67
Exercise
A. Tick ( ) the correct option.
1. Which of these is the vertical axis that is used to plot the values?
a. Bar b. Data c. Value Axis
2. Which of the following is the rectangular area bound by the two axis?
a. Plot Area b. Chart Area c. Gridlines
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
4. Which one of these tabs contains the Change Chart Type command?
a. Design b. Layout c. Format
B. Fill in the blanks using the words given below.
legend, scatter, axis titles, design, column chart
1. The ............................... chart usually displays the data in the form of vertical bars.
2. ............................... is a key that shows the meanings of symbols and colours used in the chart.
3. ............................... charts are also known as XY scatter plot charts.
4. The ............................... tab is used to change the design of a chart in MS Excel.
5. The ............................... command is used to give titles of both X-axis and Y-axis.
C. Write ‘T’ for true and ‘F’ for false.
1. We cannot create Bar chart in MS Excel. .....................
2. MS Excel does not provide any tool to improve the appearance of a chart. .....................
3. Plot area of a chart is the rectangular area bound 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.
..........................................................................................................................................................................................
Charts in Excel 65

