Order PDF of any content from our website with a little minor Fee to donate for hard work. 
For details: contact whatsapp +923028700085
Important notes based PDF Books are available in very little price, starting from 500/-PKR;
Order Now:  contact whatsapp +923028700085

VLOOKUP and HLOOKUP Functions MCQs

10 Score: 0 Attempted: 0/10 Subscribe
1. : The VLOOKUP function in Excel is used to:





2. : The HLOOKUP function in Excel is used to:





3. : In the function =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), the argument “col_index_num” refers to:





4. : What does the “range_lookup” argument in VLOOKUP/HLOOKUP control?





5. : What value should you use in the “range_lookup” argument for an exact match?





6. : What value should you use in the “range_lookup” argument for an approximate match?





7. : If VLOOKUP cannot find the lookup value, it returns:





8. : Which limitation is true for VLOOKUP?





9. : In HLOOKUP, the “row_index_num” argument is used to:





10. : Which function is more advanced and often used instead of VLOOKUP and HLOOKUP?





All Copyrights Reserved 2025 Reserved by T4Tutorials