Page 38 - iPlus_Ver_2.0_class_8
P. 38
4. You can sort more than one column at a time in a selected
range of cells. ..........................
5. The Add Level button is available under the File tab. ..........................
6. Data Labels refers to the horizontal and vertical lines in the plot area. ..........................
D. Match the following:
1. Area chart a. Trends over a period of time
2. Pie chart b. Quantitative magnitude of data
3. XY Scatter chart c. Sector showing relative size of each value
4. Line chart d. Correlation between two sets of values
Section B (Subjective)
A. Short answer type questions:
1. What is a cell range?
2. Define the following terms:
a. Data Labels
b. Legend
3. Define sorting.
4. What is a scatter chart?
B. Long answer type questions:
1. What is the use of the CONCATENATE function? Explain with an example.
2. What are the rules for entering a function?
3. Differentiate between a Column chart and a Scatter chart.
C. Competency-based/Application-based questions:
1. Suman wants to present the information in the form of a chart. She has data for a single series
and the graph must show the relative circular size of each value. Which chart type must she
use?
2. Nidhi has made a spreadsheet for the marks obtained by the students in her class in different
subjects. Which feature should she use to keep the spreadsheet updated if she has to change
marks in one of the subjects of any student?
3. John is preparing a list of students with their marks obtained in exams. He wants to arrange the
data in ascending order according to the students' names. Suggest him a feature of Excel which
can help him in doing his work quickly.
36
iPlus (Ver. 2.0)-VIII

