USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What are Advanced Text Filters used for?
|
|
Filtering cells that meet very specific requirements
|
|
|
Filtering cells containing misspelled words
|
|
|
Filtering cells containing formulas
|
|
|
Filtering cells containing cell references
|
Explanation:
Detailed explanation-1: -Advanced Filter allows you to generate a unique list of items and extract those items to another place in your worksheet or workbook. Advanced Filter has several useful features. It allows you to apply several filter criteria simultaneously to the entire data file, which AutoFilter does not.
Detailed explanation-2: -The Advanced Filter gives you the flexibility to extract your records to another location on the same worksheet or another worksheet in your workbook. It also allows the use of an “OR” statement in your Filters. ( Example: Which sales were less than $400 “OR” greater than $600).
There is 1 question to complete.