When performing a multilevel sort in Excel, what must be true for the second level of the sort to have any effect?, The source data must be formatted as a table, The first level must have duplicate values, The data must be filtered before sorting, All columns must be sorted alphabetically, What is the most important rule before sorting any dataset in Excel?, Ensure the first column always has text only, Select only the column you want to sort, Ensure the source data is contiguous for record integrity, Turn off the gridlines, Which of the following is true about Custom Lists?, Excel only knows alphabetical order, Excel already knows the days and the months, Excel cannot sort text unless you convert it to numbers, Excel requires administrative permission to use a custom list, When would you create a custom list in Excel, To sort text in an order that is not alphabetical, To change the worksheet font type, To lock cells so they cannot be edited, To automatically calculate totals, Which sorting method allows you to sort by Department, then by Acuity, then by LOS?, AutoSum, Custom Sort, Flash Fill, Quick sort (A to Z or Z to A)C1:C17

Excel Sorting Skills

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?