Page 36 - TP_iPlus_V2.1_Class8
P. 36
9 Click on the Add 8 Click on the Order box to select A
Level button to add 7 Click on the Sort On box to Z (for text) and Smallest to Largest
a new criteria. to select Cell Values option. (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
11 Click on the OK button.
specify more criteria.
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.
To Sum Up
Excel allows users to create custom formulas to perform calculations on their data.
Excel also contains built-in formulas called functions that make it easy to perform
common calculations on data.
A group of selected cells is called a range.
A cell reference refers to a cell or a range of cells on a worksheet that can be used to
find the values or data.
Functions are predefined formulas in Excel to perform both simple and complex
calculations.
A chart is a visual or graphical representation of data from a worksheet which is very
useful for instant analysis and decision making.
34
iPlus (Ver. 2.1)-VIII

