Database/Excel

What are the columns in bold text called?

• Rows

• Identifiers

• Field names

• Headings

Which of these is the 'key field'?

• Column 1

• Column 2

• Column 3

• Column 4

What's the formula for the total budget?

• =sum(f1 * g2)

• =sum(1.05 * g2)

• =sum(f2 * 1.05)

• =sum(e2 + f2 * g2)

What's the formula for the 'total with fees'?

• =sum(f2 * g2 + 1.04)

• =sum(f2 *1.04)

• =sum(h2 * 1.04)

• =sum(i2 * 1.04)

Which of these fields would be the most efficient for a search?

• Customer ID

• Surname

• Forename

• Date of Birth

A method of displaying records in a database that match specific criteria?

• Filter

• Sort

• Validation

• Verification

A unique identifying field is known as?

• Primary key

• Unique identifier

• Verification

• Important field

Which of these is not a type of validation?

• Range

• Proof reading

• Presence

• Limit

A method for checking data entered correctly?

• Data types

• Query

• Validation

• Verification

What is a database?

• A calculator

• A device to load information onto the computer

• A structured collection of information

• A piece of software to do calculations