Forward Interview Questions, Process, and Tips

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

It just like like a screen test they will ask you questions based on your cv

It will hardly take 30minutes to complete the test.

It will take hardly 30 minutes to complete coding test.

Q1. A technical person will take your interview it will about 20 to 30minutes
Add your answer
Q2. What is difference between list and tuple? They will ask to code for some questions?
Add your answer

DSA questions asked in an interview

Round duration - 55 Minutes
Round difficulty - Easy

Timing - evening
Interviewer was friendly.

Q1. 
Number of Islands Problem Statement
You are provided with a 2-dimensional matrix having N rows and M columns, containing only 1s (land) and 0s (water). Your goal is to determine the number of islands in t...read more
Ans. 
Count the number of islands in a 2D matrix of 1s and 0s.
• Iterate through the matrix and perform depth-first search (DFS) to find connected 1s.

• Mark visited cells to avoid redundant calculations.

• Increment island count whenever a new island is encountered.
Answered by AI
Add your answer

Round duration - 55 Minutes
Round difficulty - Easy

Timing - afternoon
Interviewer was friendly

Q1. 
Move Zeroes to End
Given an unsorted array of integers, rearrange the elements such that all the zeroes are moved to the end, while maintaining the order of non-zero elements.
Input:
The first line cont...read more
Ans. 
Given an unsorted array of integers, move all zeroes to the end while maintaining the order of non-zero elements.
• Iterate through the array and maintain two pointers, one for the current position and one for the position to swap with.

• If the current element is non-zero, swap it with the element at the swap pointer and increment the swap pointer.

• After iterating through the array, fill the remaining positions with zeroes.

• E...read more
Answered by AI
Add your answer
Q2. 
Asteroid Collision Problem Description
Given an array/list ASTEROIDS representing asteroids aligned in a row, each element's absolute value identifies the asteroid's size, while its sign indicates the dir...read more
Ans. 
Determine the state of asteroids after collisions occur in a row.
• Iterate through the array of asteroids and simulate collisions between adjacent asteroids moving in opposite directions.

• If two asteroids collide, the larger one survives while the smaller one is destroyed.

• Continue this process until no more collisions can occur.

• Return the array of remaining asteroids after all collisions have been resolved.
Answered by AI
Add your answer

Round duration - 55 Minutes
Round difficulty - Easy

Timing - evening
interviewer was friendly