Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    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

| 30 31 32 33 34 35 36 37 38 39 40 |