Bringing order to the universe!
When initially exploring a dataset, it's often useful to sort the data so you can view the highest and lowest values. Sorting is useful for not only understanding the data, but spotting suspicious values that could be natural outliers or errors in data collection.
In this exercise, you'll practice sorting one and two columns, and identify the parent planet that has the moon with the smallest mean radius.
This exercise is part of the course
Data Analysis in Google Sheets
Exercise instructions
- In column
E
, sort the values in theName
column. - In columns
F
andG
, sort bothParent
andMean radius (km)
in ascending order of radius.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
