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