NEW
Font size
WorksheetsExcel as Database
Total questions: 12
Worksheet time: 6mins
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
___________ allows you to set certain rules to restrict the type of data or values to be entered in a cell.
Criteria
Data Validation
Chart
None
__________ is when you want to sort your data on the basis of more than one column.
Multi-level column sorting
Multiple column sorting
