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
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