[go: up one dir, main page]
Scribd
Upload
68 views14 pages

Sorting Data: Ch#5: MS Excel Advanced Features

This document discusses sorting data in Microsoft Excel. It defines sorting as rearranging data in ascending or descending order. There are two main types of sorting: ascending order, which arranges data from lowest to highest, and descending order, which arranges data from highest to lowest. Sorting can be done on a single column to organize the data, such as sorting student marks in descending order. Sorting makes data easier to read, understand and search, reducing complexity and helping with effective decision making.

Uploaded by

Fariha Fariha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
68 views14 pages

Sorting Data: Ch#5: MS Excel Advanced Features

This document discusses sorting data in Microsoft Excel. It defines sorting as rearranging data in ascending or descending order. There are two main types of sorting: ascending order, which arranges data from lowest to highest, and descending order, which arranges data from highest to lowest. Sorting can be done on a single column to organize the data, such as sorting student marks in descending order. Sorting makes data easier to read, understand and search, reducing complexity and helping with effective decision making.

Uploaded by

Fariha Fariha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 14

Sorting Data

Ch#5: MS Excel Advanced Features


Previous Knowledge

• Concept of Rows & Column.


• Cell.
• To enter Data in the Excel.
Objectives
• Sorting Data
• Importance of Sorting
• Types of Sorting
• Sorting on One column
Sorting
The Physical rearrangement of
data in ascending or descending
order is called Sorting
Sorting….
• You can sort data
alphbatically,
numerically, dates or
times, colours etc.BY
highlighting cells
and then pressing the
short keys.
Importance of Sorting
• It makes the data easy to read &
understand.
• It reduces the complexity of the
program.
• It helps & save time in searching the
data.
• It helps in making effective decisions.
Types of Sorting
• Ascending Order
• Descending Order
Ascending Order
Ascending Order

Arranging the data in increasing order.


For example: Letters from A to Z, numbers from
lowest to highest.
Descending Order
Descending Order

Arranging the data in decreasing order.


For example: Letters from Z to A, numbers from
highest to lowest.
Sorting on One Column
• Data is arranged in
an ascending or
descending order for
only one column.
• For example: A list of
students marks in a
class in maintained
with the “Marks” of
all the students
arranged in an
descending order.
Conclusion:

• Sorting is the most useful feature of MS Excel.


• It helps in removing the complexities of data or
programs.
Thank You

You might also like