DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which is used to sort data from A-Z is____
|
|
sort ascending
|
|
|
sort descending
|
|
|
sort alphabetical
|
|
|
filter
|
Explanation:
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).
There is 1 question to complete.