Business Consultant Intern Interview Questions and Answers

xlookup is a function in Excel that allows users to search a range or array and return a value corresponding to the first match found.

• xlookup is a dynamic array function introduced in Excel 365 and Excel 2019.

• It can search vertically or horizontally, and can return values from a single cell or an array of cells.

• xlookup can perform exact matches, approximate matches, wildcard matches, and more complex lookups.

• It is a versatile replacement for older lookup functions like VLOOKU...read more

The number of Swift cars in Delhi is not readily available as it constantly changes due to sales, registrations, and other factors.

• The number of Swift cars in Delhi can vary based on factors such as sales, registrations, and scrappage.

• One way to estimate the number of Swift cars in Delhi is to look at the total number of Swift cars sold in India and then calculate the percentage that would likely be in Delhi.

• Another approach could be to contact the Regional Transport Office (...read more