Question

________ is a way to filter data based on some specific conditions.​

Answer 1

Answer:

• The Select statement of the database query helps us to select data in a tabular form based on some specific conditions.
• In Microsoft Excel, The  FILTER function filters a range of data based on supplied criteria or specific condition, and extracts matching records.

Explanation:

• The Select statement of the database query helps us to select data in a tabular form based on some specific conditions.
• The basic structure of an SQL expression consists of three clauses : select , form and where .
• The select clause is used to list the attributes desired in the result of a query.
• The from clause lists the tables to be scanned in the evaluation of the query.
• The where clause consists of a predicate involving attributes of the relations that appear in the form clause.
• In Microsoft Excel, The  FILTER function filters a range of data based on supplied criteria or specific condition, and extracts matching records.
• The FILTER function belongs to the category of Dynamic Arrays functions. The result of the function is an array of values that automatically spills into a range of cells, starting from the cell where we enter a formula.
• The syntax of the FILTER function is :

        FILTER(array, include, [if_empty])

       Where:

• Array  - the range or array of values that we want to filter.
• Include (required) - the specific condition supplied as a Boolean array (TRUE and FALSE values).
• If_empty (optional) - the value that should be returned when no entries meet the criteria.