Answered

you created a spreadsheet with a list of the students in your class and contact information for them. for which task should you use the filter function to display the desired result?this task contains the radio buttons and checkboxes for options. press the enter key to select the option. option a



Answer :

Vinodhiniss

If you want to display a list of the students who live in a particular city, you have to use the filter function.

What is a filter function?

  • We can use the FILTER function to filter a variety of data according to criteria we provide.
  • Based on given criteria, the Excel FILTER function filters a set of data and extracts matched entries.
  • Array, include, and if empty are the three inputs required by the FILTER function.
  • The range or array to filter is called an array.
  • One or more logical tests should make up the include argument.
  • Based on the examination of values from the array, these tests should return TRUE or FALSE.
  • FILTER generates dynamic results.
  • The FILTER results will automatically update when the source data values change or the source data array is resized.
  • The results of FILTER will leak onto the worksheet into several cells.

To learn more about filter function, refer:

https://brainly.com/question/29730269

#SPJ4

Other Questions