DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
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: -Complex Filters For example, with an AutoFilter, you can select two specific customers, and two products for those selected customers. With an Advanced Filter, you can create OR conditions between columns, such as Customer A OR Product B-you can’t do that in an AutoFilter!
There is 1 question to complete.