Learning Resources
Data Operations
Data Operations
Database Management
It refers to managing of data in a database i.e. adding, removing, updating, sorting data in a database. It offers the facility to sort the database by
- Using one sort column
- Using two, three or more sort column
Database management also provides following options in MS-EXCEL
- Adding a record
- Deleting a record
- Filter and multiple filter
Filter and multiple filter
Filtering is a quick and easy way to find and work with a subset of data in a list. A filtered list displays only the rows that meet the criteria specified for a column.
Automatic filter options
|
To |
Click |
|
Display all rows |
All |
|
Display all rows that fall within the upper or lower limits you specify, either by item or percentage |
Top 10 |
|
Apply two criteria values within the current column, or use comparison operators other than AND (the default operator) |
Custom |
|
Display only rows that contain a blank cell in the column |
Blanks |
|
Display only rows that contain a value in the column |
NonBlanks |