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

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

Which function you can use to quickly calculate rows of related data?Group of answer choicesSubtotalGroupUngroupRelationships

A listing of all possible values in a data set and how often they occurred is called a data _____________________.Group of answer choicesfrequencydistributionpercentagevariable

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