Question

A features that displays only the data in column (s) according to specied criteria

Answer 1

Here you will find a list of common important questions on microsoft excel in MCQ quiz style with answer for competitive exams and interviews. These frequently asked sample questions on MS Excel are given with correct choice of answer that you can check instantly. Presently we have added total 5 sets of questions on microsoft excel for you to practice. We will keep adding more questions and provide this question bank in PDF format, so that you can download them instantly in E-book style.

Answer 2

Excel FILTER features displays only the data in column (s) according to specified criteria .

Explanation:

• 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.