DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS 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
|
|
|
Copy
|
|
|
Paste
|
|
|
Paint
|
Explanation:
Detailed explanation-1: -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-2: -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.
There is 1 question to complete.