Excel
Access
Big Data
100

What is spreadsheet?

Excel

100

What is database?

Access

100

What is the massive amounts of data collected and analysed on an ongoing basis?

Volume

200

Which function returns the lowest value in a specified range of cells?

MIN

200

What is field in a database table that provides a unique identifier for a record/entity?

Primary key

200

What is how quickly data is generated, processed and turned into useful information?

Velocity

300

Which function evaluates a condition and displays one value in a cell if the condition is True and an alternative output if the condition is False?

IF

300

What is database that stores data using two or more linked tables?

Relational database

300

What is the range of data formats and data types collected?

Variety

400

Which function checks all the cells in a specified range and outputs how many contain a numeric value?

COUNT

400

What is feature in database applications for linking tables together?

Relationship

400

What is how useful data is to an organisation?

Value

500

Spreadsheet containing data that represents a real-life scenario

Spreadsheet model?

500

What is database that stores all data items using one table?

Flat-file database

500

What is accuracy and quality of data?

Veracity

M
e
n
u