Excel as Database

This is an organised collection of information.

• Database

• Chart

• Sorting

It is a small screen that contains the fields of a database along with the space to add, modify or view a record.

• Worksheet

• Form

• Frame

The structure of database is made up of _________ and _________.

• Frame, Form

• Form, Fields

• Fields, Records

• Records. Form

This is used to rearrange data in a specific order.

• Sorting

• Filtering

• Data Validation

This button in the sheet1 dialog box lets you search a record by entering data in a uniquely identified field.

• Find Prev

• New

• Criteria

It contains data and information about one person, item or an organization in a database.

• Record

• Field

• Field Name

Click on the _____________ button present on the Data tab to remove the filter.

• Delete

• Clear

• Clean

• Remove

___________ feature temporarily hides unwanted data from being viewed.

• Data Validation

• Criteria

• Filtering

• Sorting

_________ used for specifying complex criteria.

• AutoFilter

• Filter

• Advanced Filter

• Complex Filter

To remove the previous sorting condition, click on the ___________ button.

• Add level button

• Delete level button

• Clear button

• Remove button