Grade 8 - Managing Data

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

• Query

• Formula

• Function

• Report

Raw information, values, facts and figures

• Data Sheet

• Database

• Data

• Model

Primary Key cannot be duplicated

• True

• False

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:

• COUNT(B2:D3)

• =COUNT(B2:D3)

• =COUNT B2:D3]

• =COUNT(B2-D3)

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:

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

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

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

• =IF(B4>=100 "big" "sma'')

This is a SQL query. What does Students means in line 2:

SELECT Students.Name, Student.Email

FROM Students

Where Students.StudentID = VS0003

• It is the Column Name

• It is the Row Name

• It is the Table Name

• It is the Field Name

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

• Report

• Field

• Condition

• Query

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

• Data Collection

• Data capture Form

• Data Entry

• Database

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

• Primary Key

• Query

• Database

• Record