Data Citizenship Level 4 assessment exemplar Part 2: Manipulating the data

Delete unwanted columns (for Task 4):

Delete unwanted rows (for Task 5):

Learn how to make a calculated column and thinking more about data quality (Practice for Task 6):

Doing conditional formatting (to change the colour of the cells depending on the value) (Practice for Task 6):

Calculated columns and conditional formatting (for Task 6):

Creating a summary table and getting the unique values from a column (for Task 7):

Using SumIf to add together all the matching values from a column (like adding up all the mammals) (practice for Task 7):

Using the AverageIf function to average all the matching values from a column (like averaging all the mammals life expectancy values) (for Task 7):