NEW
Font size
WorksheetsExcel as Database Revision
Total questions: 10
Worksheet time: 5mins
The structure of Database is made up of _____________
Fields
Records
Both Fields and Records
None
_____________ allows you to set certain rules to restrict the type of data or values to be entered in a cell.
Criteria
Data Validation
Field Name
All the above
If data entered does not meet the specified criteria, Excel prompts an 'Invalid Data' warning box. Click on ________ to change the value in the cell.
Yes
No
Cancel
Help
____________ feature temporarily hides unwanted data from being viewed.
Sorting
Hide
Filtering
None of the above
___________ is used for specifying complex criteria.
Criteria
Advanced Criteria
Auto Filter
Advanced Filter
Rearranging data in a specific order is called ____________.
Sorting
Filtering
Arranging
Validation
You cannot add anew record in an empty Excel sheet using Form feature
True
False
A field is a ___________ in database.
Row
Column
A record is a __________ in database.
Row
Column
Filter option is available in ____________ tab.
Home
Insert
View
Data
