Page 35 - iPlus_Ver_2.0_class_8
P. 35
3 Click on the Sort & Filter command.
2 Click on
Home tab.
4 Click on
the Custom
Sort option.
1 Select
the range of
columns to
be sorted.
9 Click on the Add 8 Click on the Order box to select
Level button to 7 Click on the Sort On box A to Z (for text) and Smallest to
define a new criteria. to select Cell Values option. Largest (for numbers).
5 Check My data has headers checkbox if the
6 Click on the Sort by box to selected columns have a heading at the top.
select a column head for sorting.
10 Repeat steps 6 to 8 to
sort Marks in previous term 11 Click on the OK button.
column in descending order.
The data will be sorted according to the criteria defined.
Quick Byte
The sorting can also be done through the Sort & Filter group under the Data tab by
selecting and commands for sorting in ascending and descending order,
respectively. To create a custom sort, click on command.
33
Spreadsheet—Functions and Charts

