USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Filter
|
|
|
Sort
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Filters can be used to narrow down the data in your worksheet and hide parts of it from view. While it may sound a little like grouping, filtering is different in the way that it allows you to qualify and display only the data that interests you.
Detailed explanation-2: -Answer :-Narrowing down of data in worksheet can be done by Filtering data option.
Detailed explanation-3: -Text Filters In Excel If we put the letter “a” in the text box next to the “begins with” option, then Excel will show only the items in the Country column that start with the letter “a.” If you want to be more specific and select a particular country then uncheck Select all.
Detailed explanation-4: -The FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER(A5:D20, C5:C20=H2, "") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").