Page 60 - TP_Modular_V2.1_Class7
P. 60
Step 3 Type the desired field value which
you want to search. In this case, we
have typed the Employee Code
value A1114.
Step 4 Press the Enter key. The searched
record will appear if exist.
Deleting a Record Typing value to search Searched result
Perform the following steps to delete a
record:
Step 1 Move on the record which you want to delete by clicking on
the Find Next or Find Prev button.
Step 2 Click on the Delete button. The record will be deleted from the
worksheet.
SORTING DATA
Deleting a record
Excel can arrange the selected data in ascending or descending order.
This is called sorting of data. To sort data, follow the given steps:
Step 1 Select the data to be sorted.
Step 2 Click on the Sort & Filter command from
Editing group under the Home tab to open a
drop-down list.
Step 3 Click on the Sort A to Z (for text) and Sort
smallest to largest (for numbers) to sort the
data in ascending order.
The selected data gets arranged in ascending
order.
Unsorted data Sorted data
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.
To use Custom Sort, follow the given steps:
Step 1 Select the range of columns to be sorted.
Step 2 Click Sort & Filter command from Editing group
under Home tab to open a drop-down list.
Step 3 Click Custom Sort from the drop-down list to open
Sort dialog box.
Step 4 Check My data has headers checkbox if the selected Unsorted data
columns have a heading at the top.
58 Modular (Ver. 2.1)-VII

