4.Question 4Fill 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. 1 pointrightfalseneighboringsame

Question 4Fill in the blank: When searching for the value in the first argument of the function, VLOOKUP looks in the _____ column of the specified location. 1 pointfalseleftmosttruerightmost

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 true for VLOOKUP()? 1 pointThe main difference between HLOOKUP() and VLOOKUP() is that HLookUp looks for the specified value across the top row while VLookUp looks for it in the left-most column.VLOOKUP() is only able to return one value at a time.If a user places an invalid value in the LookUp_value the function is able to tell the user that the value inputted isn’t in the table.The results column needs to be part of the defined lookup table.

Question 19Which spreadsheet function vertically searches for a certain value in a column in order to return a corresponding piece of information?1 pointVALUEVIEWVALIDATEVLOOKUP

In Google Sheets, what does the function “VLOOKUP” do?