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

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

You need to define a criteria range if you want to:Group of answer choicesDo advanced filteringUse VLookup functionUse HLookup functiondo any kind of filtering

The Excel function HLOOKUP looks up a value in the top row of a table and returns a value in the same column from a row you specify. Group of answer choicesTrueFalse

The intersection of a column and a row in a worksheet is called____Group of answer choicesCellValueAddressColumn

What function allows the user to pull a subset of data from a larger table of data based on some criterion?Group of answer choicesIFSUMIFVLOOKUPCOUNTIF