Search for courses or lessons
Redeem a coupon
Start free trial
Which of the following data characteristics is critical in order to allow efficient sorting of data?
Consistent data types (e.g. text versus numbers) in the column
No entirely blank rows in the data set
A good header row
When setting up a custom sort, you can sort based on more than just the Cell Values. What options do you have to Sort On?
Values, cell colors, icons
Values, cell colors, formulas
Values, cell colors, fonts
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 by the first column, then select the second column and sort by that column
Sort the data, then select the range of ties and sort that
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement