Form 4 - CSEC Information Technology Quiz

Which of the following is a valid cell reference in Excel?

• A12

• 12A

• AB#12

• @A12

What is the default file extension for Excel workbooks?

• .docx

• .xlsx

• .pptx

• .accdb

The __________ function searches for a value in the first column of a range and returns a value in the same row from another column.

• conditions

• VLOOKUP

• MAX

• AVERAGE

• highlighting

Conditional formatting is a feature that applies formatting based on specified __________.

• AVERAGE

• conditions

• VLOOKUP

• highlighting

• MAX

Which of the following is a database object in Microsoft Access?

• Table

• Query

• Form

• All of the above

What is the purpose of a primary key in a database table?

• To allow duplicate entries

• To uniquely identify each record

• To store numeric data

• To organize data alphabetically

A __________ stores data in rows and columns, while a __________ retrieves specific data from one or more tables.

• query

• consistency

• keys

• relationships

• table

__________ link tables through common fields and ensure data __________.

• relationships

• table

• query

• consistency

• keys

A table in Microsoft Access cannot have duplicate primary keys.

• True

• False

Queries can retrieve data only from one table at a time.

• True

• False