Page 69 - ModularV1.1 _c7_flipbook
P. 69
Periodic Assessment-3
(Based on chapters 6 & 7)
A. Rewrite the incorrect statements.
1. Data validation means to allow the user to enter the entire range of values in a particular cell or
range of cells.
..........................................................................................................................................................................................
2. The Pivot Table feature of MS Excel allows you to analyse only small amounts of data.
...........................................................................................................................................................................
3. Bar Chart is used to display the quantitative magnitude of data graphically.
..........................................................................................................................................................................................
4. $ sign can be used only for absolute referencing.
..........................................................................................................................................................................................
5. Conditional Formatting command is present under the Data tab.
..........................................................................................................................................................................................
B. State the use and one example of each.
1. Column chart ..........................................................................................................................................
2. Pie chart ..........................................................................................................................................
3. Area chart ..........................................................................................................................................
4. Bar chart ..........................................................................................................................................
5. XY Scatter Plot chart ..........................................................................................................................................
C. Application based question.
Sanjay is preparing an analysis sheet for his office. He wants to present information by showing
names of salesmen making maximum sales to those making minimum sales.
How can he do so?
....................................................................................................................................................................................................
D. Match the following columns.
Column A Column B
1. X-axis a. includes data values, category names, series names, etc.
2. Y- axis b. a key that shows the meanings of symbols and colours used in
the chart
3. Legend c. category axis
4. Chart Area d. value axis
5. Data Labels e. includes all objects and elements in a chart
Periodic Assessment-3 67

