DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sort A to Z
|
|
|
Sort Z to A
|
|
|
Custom sort
|
|
|
Sort and filter
|
Detailed explanation-1: -VBA Sort Range | (Descending, Multiple Columns, Sort Orientation. To sort a range of cells using VBA, you need to use the “SORT” method that allows you to set a single key (column) or multiple keys (for multiple columns) to sort.
Detailed explanation-2: -In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort. Select a cell within the data. Select Home > Sort & Filter. Or, select Data > Sort.
Detailed explanation-3: -Sort by more than one column or row Select any cell within your data range. On the Data tab, in the Sort & Filter group, click Custom Sort. In the Custom Sort dialog box, under Column, in the Sort by box, select the first column that you want to sort.