USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
sort ascending
|
|
|
sort descending
|
|
|
Copy
|
|
|
Paste
|
|
|
Paint
|
Detailed explanation-1: -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.
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.
Detailed explanation-4: -In general terms, Ascending means smallest to largest, 0 to 9, and/or A to Z and Descending means largest to smallest, 9 to 0, and/or Z to A. Ascending order means the smallest or first or earliest in the order will appear at the top of the list: For numbers or amounts, the sort is smallest to largest.