Back to lesson
1. Which of the following data characteristics is critical in order to allow efficient sorting of data?
No entirely blank rows in the data set
Consistent data types in the column
A good header row
2. Which of the following things can be sorted?
Values, cell colors and fonts
Values, cell colors and icons
Values, cell colors and formulas
3. Which of the following methods is the best way to perform a multi-level sort?
Sort by the first column, then select the second column and sort by that column
Sort your data, then select the range of ties and sort that
Go to Data > Sort and add as many sorting levels as you need
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement