Question

which function is a way to filter data based on some specific conditions. a.auto filter b.standard filter c.both a and b​

Answer 1

Answer:

A) Auto filter...

Explanation:

Select the Data tab, then click the Filter command. A drop-down arrow will appear in the header cell for each column. ...

Click the drop-down arrow for the column you want to filter. ...

The Filter menu will appear. ...

The Custom AutoFilter dialog box will appear. ...

The data will be filtered by the selected text filter.