Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 62 - Data_Science_Part_A C12
P. 62

    Reboot

                  Give the keyboard shortcuts for the following:
                  a.   To print a spreadsheet

                  b.  To open a new file

                  c.   To format text to bold

            3.11 ADVANCED FEATURES IN CALC

            There are various advanced features of Calc. Let us learn about some of them in detail.

            3.11.1 Sorting Data

            Calc spreadsheet software helps people to organise and process data by the use of columns and rows with formulas and
            some cool features. Let us understand how to sort data—arrange data alphabetically or in ascending/descending order.
            Ascending Order: Data is arranged from smallest to largest, or alphabetically from A to Z.
            Descending Order: Data is arranged from largest to smallest, or alphabetically from Z to A.
            Consider the following spreadsheet:

            In order to see the student obtaining the highest total, we need to sort the data in descending order of ‘Total’. Follow
            the given steps:
            Step 1:  Select the data to be sorted.

            Step 2:  Click on Data   Sort on the menu bar. The Sort dialog box will open.

               60   Touchpad Data Science-XII

| 57 58 59 60 61 62 63 64 65 66 67 |