CollegeShala 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

Core HTML, CSS and JS

JS deep dive and react

Q1. Mimic Promise.all, Array.flat, OTP Component etc
Add your answer

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

• Spanish

• French
Answered by AI
Add your answer

Problem solving approach check

Q1. Case study and problem solving
Add your answer
Q2. Root cause Analysis
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

Basic excel problem, and pyhton, and sql

Q1. Basic interview questions over resume
Add your answer

Q1. Basic hr questions over salary and why do you wanna work with us
Add your answer

Basic GFG questions and basic logiccal reasoning

Q1. Why are you swithcing
Ans. 
Seeking new challenges and growth opportunities in a different industry.
• Looking for a new challenge to expand my skills and knowledge

• Interested in exploring different industries and gaining diverse experience

• Seeking growth opportunities that align with my career goals
Answered by AI
Add your answer

Q1. What is sql, what is key word, tell me something about pandas and numpy, hangman puzzle
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Keywords are reserved words in SQL.
• SQL is used to retrieve, insert, update, and delete data from databases

• Keywords in SQL are reserved words that have a specific meaning and cannot be used as identifiers

• Pandas is a Python library used for data manipulation and analysis

• NumPy is a Python library used for numerical computing and array o...read more
Answered by AI
Add your answer