Page 49 - CG_v2.1_flipBooks_class_6
P. 49
Experiential Learning
Competency-based/Application-based questions Information Literacy
1. 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 that can
help him do his work quickly.
2. Akriti was making a list of all the students in her class. She wishes to sort them alphabetically.
Which type of sorting can she use for this?
Experiential Learning
LAB Activity Information Literacy
A. Create an Excel worksheet and enter the following data:
Create a column chart based on the above data. Title of the chart should be ‘Yearly Sales
Chart’. The chart should be look like this:
B. Do a poll/survey of students of your class on festivals of India. Visit https://utsav.gov.in/
and find the relevant information about each festival. Create an Excel sheet containing the
favourite festival of each student in the class and sort the data according to the name of the
student alphabetically.
Charts in Excel 47

