DATABASE FUNDAMENTALS
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sorting
|
|
|
Filtering
|
|
|
Customization
|
|
|
Clear rules
|
Detailed explanation-1: -Answer: It is called sorting. Explanation: the physical rearrangement of data in ascending or descending order is called sorting. search.
Detailed explanation-2: -Sorting is the process of ordering or arranging a given collection of elements in some particular order. We can sort a collection of numbers in ascending (increasing) or descending (decreasing) order.
Detailed explanation-3: -You can sort both text and numbers in two ways: in ascending order and descending order. Ascending means going up, so an ascending sort will arrange numbers from smallest to largest and text from A to Z. Descending means going down, or largest to smallest for numbers and Z to A for text.
Detailed explanation-4: -Sort quickly and easily Select a single cell in the column you want to sort. to perform an ascending sort (from A to Z, or smallest number to largest). to perform a descending sort (from Z to A, or largest number to smallest).