Page 35 - 2619_PlusGPT V2.1_C-8

Google Sheets
3 (Advanced- Sorting,

Filtering & Charts)

Let’s surf

Sorting Data Filtering Data
Charts Detailed Formatting of Charts

Let’s PLug-in Critical Thinking
If you get 95, 85 and 90 marks out of 100 in Maths, English and Computer Science, respectively,

then find out your average marks and exam percentage.
______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

Google Sheets is a versatile tool that allows you to manage, analyse and visualise data effectively.
In this chapter, you will learn how to sort and filter data, create informative charts and apply detailed

formatting to charts to enhance your presentations and make data tasks more efficient.

SORTING DATA

Sorting data in Google Sheets refers to organising your data in a specific order, either ascending
(A-Z or smallest to largest) or descending (Z-A or largest to smallest). This helps to arrange data in a
logical sequence, making it easier to analyse and find information.

For example, you can sort a list of names alphabetically or sort numbers from the highest to lowest
value. Google Sheets allows sorting by one or multiple columns at a time, enabling more complex data
arrangements.

Google Sheets (Advanced- Sorting, Filtering & Charts) 33