Excel as Database Revision

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