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

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 19Which spreadsheet function vertically searches for a certain value in a column in order to return a corresponding piece of information?1 pointVALUEVIEWVALIDATEVLOOKUP

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.

Question 4Fill in the blank: In a VLOOKUP function, the word false tells VLOOKUP that an _____ match is desired. 1 pointexactapproximateuncertaininexact

If you use the VLOOKUP function to find a value, which of the following are required?1) The value you want to look up2) The range where the lookup value is located3) The column number in the range that contains the return value4) You can specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value. If you do not specify anything, the default value will always be TRUE or approximate match.Question 18Select one:a.1,2,3,4b.2,3,4c.1,2,3d.1,2