Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 48 - 2632_CodeMind
P. 48

    Critical Thinking
                        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 is creating a chart in Excel. She wants to put emphasis on a significant element in the chart.
                          Which type of chart should she use to achieve this?

                                                                                              Technology Literacy
                        byte TASK                                                             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.

                                                                                                  More on Excel   47

| 43 44 45 46 47 48 49 50 51 52 53 |