Page 52 - 2619_PlusGPT V2.1_C-8

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