TVS Sundram Fasteners SAP Data Entry Operator Interview Questions and Answers

Simple and easy questions for me

Q1. Whats is H lookup?
Ans. 
HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.
• HLOOKUP stands for Horizontal Lookup.

• It is used to search for a value in the top row of a table and return a value in the same column from a specified row.

• Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

• Example: =HLOOKUP(100, A1:D4, 3, FALSE) will searc...read more
Answered by AI
Add your answer
Q2. What is v lookup?
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• VLOOKUP stands for 'Vertical Lookup'.

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column.

• The function requires four arguments: the value to search for, the range of cells to search in, the column index number...read more
Answered by AI
Add your answer

An interview with advanced Excel question