1.

Which function displays only the data in column (s) according to specified criteria?1. AVG2. Filter3. Min4. Sum

Answer» Correct Answer - Option 2 : Filter

The correct answer is Filter.

  • The Excel FILTER feature filters a collection of data based on the criteria supplied and extracts matching information.
  • The Excel FILTER feature "filters" a set of data based on the criteria supplied.
  • In simple language, the FILTER function allows you to easily extract matching records from a larger set of source data based on the criteria you provide.
  • The results of the FILTER are dynamic.
  • When the source data value changes the results from FILTER will update automatically


Discussion

No Comment Found

Related InterviewSolutions