Excel Database and Data Validation

___ is considered to be a single row

• record

• cell

_____ is used to specify the type of data that can be entered in a celll

• input message

• data validation

This alerts users by displaying an error message if invalid data is typed in a cell

• Error Alert

• Filter

This icon represents

• Auto sum

• Sort and Filter

This icon stands for

• Filter

• Data Validation

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

What is an advanage of a database?

• You can input information

• Its different to Excel

• It saves files

• Can search through and find information quickly

Which of the following statements best defines the word 'database'?

• A database is a collection of data or information which is structured and organized

• A database is a collection of statistics stored only for computers.

• A database does not collect data or information.

All the information about a person or a thing is called?

• A file

• A record

• A table

• A field