Database and Spreadsheet Quiz

Which one identifies as a cell range

• C2+D3

• C2:D3

• C2/D3

• C2-D3

A block of code that is used to perform a single, related action.

• Formula

• Function

• Query

• Report

Raw information, values, facts and figures.

• Data sheet

• Data

• Database

• Model

Why the Book Name field cannot be a primary key?

• Primary key only accepts the same value

• None of them

• Book Name can be duplicated

• Because this is unusual in database

COUNT function checks all the cells in a specified range in a spreadsheet and outputs how many contain a numeric value. Select the correct function format below:

• = COUNT B2:C6]

• = COUNT (B2:C6)

• = COUNT (B2-C6)

• COUNT(B2:C6)

IF function in a spreadsheet, this evaluates (calculates) a condition and returns different values depending on whether it was True or False. Select the correct function format below:

• =IF(B4>=100 "big" "small")

• =IF(B4>=100, big, small)

• =IF(B4>=100,"big","small")

• =IF(B4>=100,"big":"small")

Something that is checked to determine whether it is true or false.

• Report

• Query

• Field

• Condition

A computer application that is used to organise data that can then be stored, processed and accessed electronically.

• Data entry application

• Data-capture form

• Data collection software

• Database

A value that is unique for every record in a database and can be used to identify a record.

• Query

• Record

• Primary key

• Database

In a table, the primary key must be a number.

• True

• False