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

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

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

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

Question 2Fill in the blank: Data analysts can use _____ to highlight the area around cells in order to see spreadsheet data more clearly.1 pointfiltersborderspivot tablesitalics