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 Excel function VLOOKUP looks up a value in the leftmost column of a table (specified by the table_array) and returns a value in the same row from a column you specify (col_index_num).Group of answer choicesTrueFalse

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

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

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

If we type  $H$12 in Excel we are using  :Group of answer choicesRelative referencingRelative row and absolute column referencingAbsolute row and relative column referencingAbsolute referencing