Back to lesson
1. Which characteristic of a data set is essential to be able to sort the data efficiently?
Consistent data types (e.g. text versus numbers) in the column.
A good header row.
No entirely blank rows in the data set.
2. Which of these things can be sorted?
Values, cell colours, icons.
Values, cell colors, formulas.
Values, cell colors, fonts.
3. Which is the best method to sort a data set by multiple columns (i.e. a multi-level sort)?
Go to Data and click Sort and add as many sorting levels as needed.
Sort the data, then select the range of ties and sort that.
Sort by the first column, then select the second column and sort by that column.
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement