Functions and Features

Question 1

Spreadsheet

Answer 1

create worksheets
* create links between worksheets
* use a range of data types
* validate data
* create, edit and use charts
* perform calculations using a range of functions (SUM, COUNT, MAX, MIN, AVERAGE, SUMIF, COUNTIF)
* use LOOKUP functions * conditional formatting * sort and filter data
* import and export data * secure data.

Question 2

Database

Answer 2

create tables
* create relationships between tables (for RDBMS)
* use a range of data types
* validate data
* create, edit and use queries
* search and filter records * perform calculations
* create and edit formatted reports
* sort records or index on different fields
* import and export data
* secure data.

Question 3

Data visualisation

Answer 3

create/select a range of shapes
* create/select a range of chart types
* use symbols/images/charts
* show relationships and patterns
* enter, edit and format text and other content
* use colour/shading
* use of animation in charts (showing movement or changes in response to user input)