Spreadsheet rows, columns, cells and tabs

Be aware - Spreadsheets often auto-format your data

Particularly with numeric data

Numbers formatted as text will cause formula errors

Select the relevant column, and then click “Format”:

Filtering your data enables:

• Sorting of values (without mis-sorting the dataset!)

• Organisation of data

• A quick way to view and work with a subset of the data

Select the top row (column headings), and then click Data > Filter:

You can sort the data:

• From highest to lowest

• From lowest to highest

• Using other variables

Re-ordering with the data filter only allows you to filter on one column at a time:

• Sort by Gender

• Then sort by Motivation Level

When you sort by Motivation Level, you lose the sort by Gender!

Therefore you need to define sort “levels” in order to sort first by Gender, and then by the Motivation Level.

Now try this, sort by Gender and then by Motivation Level:

• Select the full range of data: Click in Cell A1 > then hold Shift + Ctrl + Arrow Down and then Arrow Right).

• Then click Data > Sort Range

• And then define the levels you wish to sort by.