Part two explains explicitly CHARTS AND CHART OPERATIONS IN MS-EXCEL (2016, 2013, 2010, 2007)
Part three explains explicitly MANIPULATIONSON SMARTART, DUAL-AXIS CHARTS, SHAPES AND MATHEMATICAL EQUATIONS IN MS-EXCEL
SORTING A DATABASE
This is the arrangement of records either in ascending or descending order for easy accessibility and retrieval of information. Sometimes there might be need for you to arrange records alphabetically, and then you sort the database. You can sort by any column of your choice.
DEFINITION OF TERMS
These are some of the database terms we will be using in this chapter.
DATA
They are raw or unprocessed facts concerning individuals or business organizations.
CHARACTER
This is the smallest entry in a database. A collection of characters is called a field or data item. For example A, B, C,…, Z or 0, 1, 2,…,9.
INFORMATION
It is also referred to as processed data. It is slightly different from data.
FIELD
This is a unit of information which forms the attribute of a record. It can also be referred to as Data Items.
FIELD NAMES
This is the column title or heading that specifies the type of data to be stored in a column or field. For example FIRST NAME, SURNAME, etc.
RECORD
This is the collection of related fields. It is commonly expressed in rows.
DATABASE
This is a collection of related records that contain information of individuals or entities which are organized structurally to enhance easy access, update, maintenance and storage with minimum redundancy.
SORTING FIELD
This is the field the sorting operation is based on.
SORTING ORDER
This is the order of the sorting operation it could be either in ascending or descending order or group of colour range, etc.
DATA RANGE
This is the entire database you want to sort which includes all the records excluding the field names.
CRITERIA
These are the conditions you use to tell Excel how it will query or sort your database.
HOW TO SORT A WORKSHEET OR DATABASE
This is the arrangement of records either in ascending or descending order for easy accessibility and retrieval of information. Sometimes there might be need for you to arrange records alphabetically, and then you sort the database. You can sort by any column of your choice.
To sort a database:
1. Open the records or database you want to sort.
2. Click the Data tab and click Sort under Sort & Fill group. This prompts the sort dialogue box.
3. If your data has a header row, check the button at the top that says “My Data has a header”. Specify the sorting column by clicking the “Sort by” drop down menu under Column. You can sort by more than one column by clicking the “Add level” tab. This will add a second sort level. In the figure shown below, there are two levels: sort by NAME and then by AGE.
Click Here http://www.microsofttut.com/2016/10/database-operations-in-ms-excel-2016.html to read more