Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 52 - 2619_PlusGPT V2.1_C-8
P. 52

    Move and resize the charts to make them fit accordingly.

                                 After the charts have been created, change the background of the charts.
                          4. Enter the following data in a new Google Sheet and draw a line chart and column chart:

                          5.  Following is a list of names entered in a Google Sheet. Create the worksheet then use
                            different features of Google Sheet as instructed.

                                 Use the sorting feature to arrange the names in alphabetical order, i.e., in ascending
                                order.

                                 Then again use the sorting feature to arrange the ages from smallest to largest.
                                 Use the same data from the above part to use the filter feature on.

                                 Use the Filter option to view only the names of all the boys.
                                 Add another filter to only see the boys whose hometown is Roorkee.
                          6.  In  a new Google Sheet create the list of ten of your  friends and  their favourite
                            movies. Also make a column telling how many times they have watched that movie
                            approximately. When the data is entered, sort it alphabetically. Use the IF function to
                            check how many of them have watched their favourite movies more than 5 times. Then
                            use the filter feature to only display the names of the friends who have watched their
                            favourite movies less than 5 times.

                                                              For The Teacher

                             Describe the different types of charts provided by Google Sheets to the students.

                             Talk to the students about the way to create a chart.

                      50    Premium Edition-VIII

| 47 48 49 50 51 52 53 54 55 56 57 |