rue or False: When you select the Filter button on the Data ribbon, Excel automatically filters the data based on choices that you have already made in the drop-down menus next to each heading. 1 pointTrue

What is an Excel feature that displays only the data in column (s) according to specified criteria? *1 pointFilteringSortingFormulaPivot

What is an Excel feature that displays only the data in column (s) according to specified criteria?Group of answer choicesFormulaPivotFilteringSorting

After filtering a column and getting the results, in which two ways can you return to showing all the data in a column? Select two answers. 1 pointclear the filter  turn filtering offrefresh the column  refresh the worksheet

Which option allows you to quickly filter data based on the values present in the Profits column in MS Excel?ACustom SortBAdvanced FilterCAutoFilterDConditional Formatting

Which feature in Excel enables you to precisely control what information is displayed in a visualization such as a chart?1 pointSortingFiltersPivot TablesSparklines