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

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

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

Fill in the blank: In a VLOOKUP function, the value of the third argument tells VLOOKUP to return the value in the _____ row from the specified column.

Which of the following is NOT possible with VLOOKUP?*You can lookup values located in a different worksheet.You can lookup values located in a column to the right of the column that contains the lookup value.You can lookup values located in a column to the left of the column that contains the lookup value.You can lookup values such as text, numbers or characters.