3LOQ Labs Data Science Intern Interview Questions and Answers

Q1. Advanced formulas of Excel
Ans. 
Advanced Excel formulas are complex functions used for data analysis and manipulation.
• Advanced formulas in Excel include VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and IFERROR.

• These formulas are used for tasks like data lookup, conditional calculations, and summarizing data.

• For example, VLOOKUP is used to search for a value in a table and return a corresponding value from another column.
Answered by AI
Add your answer

Q1. How to calculate requirement of Banana is a city like Mumbai
Ans. 
The requirement of bananas in a city like Mumbai can be calculated based on population, consumption habits, and availability.
• Calculate the population of Mumbai

• Estimate the average consumption of bananas per person

• Consider factors like tourism and events that may increase demand

• Take into account the availability of bananas from local markets and imports
Answered by AI
Add your answer
Q2. How to know , difference between a good or bad retailer
Ans. 
A good retailer focuses on customer satisfaction, product quality, and efficient operations.
• Good retailers prioritize customer satisfaction by providing excellent customer service and addressing customer needs.

• Good retailers offer high-quality products that meet customer expectations.

• Good retailers have efficient operations, including inventory management, supply chain logistics, and streamlined processes.

• Bad retailers...read more
Answered by AI
Add your answer
Q3. Simple SQL questions
Add your answer

Q1. Languages known
Ans. 
I am fluent in English, Spanish, and French.
• English

• Spanish

• French
Answered by AI
Add your answer

Q1. Discussion on sales, areas and target
Add your answer

Q1. Discussion about product, target etc
Add your answer

Contracts review and abstraction

Q1. Contracts and essential elements
Add your answer

DSA questions asked in an interview