FabHotels Data Entry Executive Interview Questions and Answers

Yes, I am proficient in MS Excel formulas.

• I am familiar with basic formulas such as SUM, AVERAGE, COUNT, etc.

• I can also use more complex formulas such as VLOOKUP, IF, INDEX-MATCH, etc.

• I am comfortable working with arrays and nested formulas.

• I have experience using Excel for data analysis and reporting.

• I am always willing to learn new formulas and techniques to improve my skills.

VLOOKUP and INDEX-MATCH are Excel formulas used to search and retrieve data from a table.

• VLOOKUP searches for a value in the first column of a table and returns a corresponding value in the same row from a specified column.

• INDEX-MATCH uses the INDEX function to find the position of a value in a table and the MATCH function to retrieve the corresponding value from another column.

• VLOOKUP is simpler to use but has limitat...read more