Page 63 - modular4.0
P. 63
Chapter Profile
Deleting a Record
Follow the given steps to delete a record:
2 Click on the
Delete button.
1 Move on the record which
you want to delete by
clicking on the Find Next
or Find Prev button.
The record will be deleted from the worksheet.
SORTING DATA
Excel can arrange the selected data in ascending or descending order. This is called sorting of data.
Follow the given steps to sort data:
2 Click on the Sort & Filter command.
1 Select a column
or range of data
to be sorted.
3 Select Sort A to Z (for text) or Sort Smallest to Largest
(for numbers) to sort the data in ascending order.
Custom Sort
In case, more than one column are to be sorted in such a way that the first column is ascending
order and if some data is same for more than one rows then the second column of such rows gets
sorted in descending order. You can do this in Excel using Custom Sort.
Excel as Database 61

