Grade 7 Using Excel as Database-ICT

Where rows and columns meet are referred to as

• Blocks
• Cells
• Boxes

Excel refers to files as

• Documents
• Workbooks
• data bases

A column within a database that contains only one type of data is called _________________

• Record

• Field

• Data

• Data Types

________________ is a collection of facts, or unprocessed information.

• Record

• Field

• Data

• Data Types

A set of rules or conditions that must be met. Often used in searches.

• Field

• Criteria

• Query

• Record

A complete set of fields, for example one pupil's school record.

• Query

• Record

• Field

• Criteria

It's easy to add or search existing records to a database.

• True

• False

A record is a single piece of data such as a name or date of birth.

• True

• False

Databases store information in __________, which are made up of columns and rows.

• tabs
• tables
• ribbons
• image files

What options are available by default on the Quick Access Toolbar? 

• Save, Redo and Undo
• Print, Save and Redo
• Redo, Undo and Help
• Print, Save and Delete