FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You have a list which contains all students information form all classes.but you want to see only one class.Which Excel feature should we use?
A
Validation
B
Auto filter
C
Conditional formatting
D
Auto series
Explanation: 

Detailed explanation-1: -Use the AutoFilter feature to find, show, or hide values-in one or more columns of data. You can filter based on choices you make from a list, or search to find the data that you seek. When you filter data, entire rows will be hidden if the values in one or more columns don’t meet the filtering criteria.

Detailed explanation-2: -A “Custom Filter” is an Excel filter option that allows us to put certain conditions to get our values. For example, in example 2, the condition marked above 50 in mathematics or above 300 in the total marks. Let us learn custom filters by example 2. Select any cell in the row header.

Detailed explanation-3: -AutoFilter allows filtering data with a maximum of 2 criteria, and those conditions are specified directly in the Custom AutoFilter dialog box. Using Advanced Filter, you can find rows that meet multiple criteria in multiple columns, and the advanced criteria need to be entered in a separate range on your worksheet.

There is 1 question to complete.
Previous
Next