Question

Is the question true or false = The Filter the list,in-place option prepares the filtered list at new place

Answer 1

Answer:

Select a cell in the data table.

On the Data tab of the Ribbon, in the Sort & Filter group, click Advanced.

For Action, select Filter the list, in-place.

For List range, select the data table.

For Criteria range, select C1:C1 – the criteria heading and formula cells.

Click OK, to see the results.

Answer 2

Answer:

the filter the list in place option prepares the filtered list at new place