Back to School Sale -
20% off all courses with code BTS2019
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?
No entirely blank rows in the data set
Consistent data types in the column
A good header row
Which of the following things can be sorted?
Values, cell colors and icons
Values, cell colors and formulas
Values, cell colors and fonts
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 your 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