USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
sort ascending
|
|
|
sort descending
|
|
|
sort alphabetical
|
|
|
filter
|
Detailed explanation-1: -CTRL + S: sort the current column in ascending order. CTRL + Shift + S: sort the current column in descending order. CTRL + Q: clear the sort for current column in single column sort. CTRL + J: clear the sort for current column in multi-level sort.
Detailed explanation-2: -Select a single cell in the column you want to sort. Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest). Click Sort Z to A to perform a descending sort (Z to A or largest number to smallest).
Detailed explanation-3: -Sorting is the process of arranging data in in ascending or descending order on the basis of one or more columns. 2. You can access sorting feature by clicking on data tab > sort and filter group > sort.