Page 34 - Trackpad_ipro 4.1_Class8
P. 34
9 Click on the Add 8 Click on the Order box to select
Level button to define 7 Click on the Sort On box A to Z (for text) and Smallest to
a new criteria. to select Cell Values option. Largest (for numbers).
10 Repeat steps 6 to 8 to 5 Check My data has headers checkbox if the
sort Marks in previous term selected columns have a heading at the top.
column in descending order.
6 Click on the Sort by box to select 11 Click on the OK button.
a column head for sorting.
The data will be sorted according to the criteria defined.
Clickipedia
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.
If Excel was a magical library, how would you sort books and filter books you
had read?
Reb t
Excel allows users to create custom formulas to perform calculations on their data.
A cell reference is a cell address that can be used in a formula to denote a specific cell.
The equal sign tells Excel that the succeeding characters constitute a formula.
A group of selected cells is called a range.
Excel also contains built-in formulas called functions that make it easy to perform common
calculations on data.
Charts make it easier to draw comparisons, analyse growth and relationships among the
values.
32 iPro (Ver. 4.1)-VIII

