USING MICROSOFT EXCEL
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sort and filter
|
|
|
Insert
|
|
|
Order
|
|
|
None of the above
|
Detailed explanation-1: -Answer: 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-2: -Sorting data means to arrange it in order .
Detailed explanation-3: -On the Data tab, in the Sort & Filter group, click Sort. In the Sort dialog box, under Column, in the Sort by box, select the first column that you want to sort. Under Sort On, select the type of sort.
Detailed explanation-4: -To focus on a specific set of your data, you can filter a range of cells or a table. Click any cell in the range or table. On the HOME tab, click Sort & Filter, and click Filter. Click a drop-down arrow at the top of one of the columns to display its filter options.
Detailed explanation-5: -The filter tool gives you the ability to filter a column of data within a table to isolate the key components you need. The sorting tool allows you to sort by date, number, alphabetic order and more. In the following example, we will explore the usage of sorting and filtering and show some advanced sorting techniques.