EXL Service
300+ Interview Questions and Answers
Q1. If I have 333 digits to number pages of a book, How many pages can I number ?
333 digits can number 166 pages of a book.
Each page number takes up 2 digits.
The first page is numbered 01.
The last page that can be numbered is 166.
The remaining 2 digits are used for the cover page or other information.
Q2. You have 20 red balls, 14 blue balls. You draw out balls, 2 at a time. If they are of same color, add a blue ball the pile. If the are of different colors, add a red ball to the pile. (i) will the color of the ...
read moreDrawing balls and adding to pile based on color. Will the last ball left be unique and what color?
Drawing 2 balls at a time and adding to pile based on color
If same color, add a blue ball. If different color, add a red ball
Question asks if last ball left will be unique and what color it will be
Q3. You have 3 slices of bread, and a toaster. You can put in 2 slices of bread at a time. Each time, only one side of the bread gets cooked. How much minimum time is needed for cooking 3 slices on both sides ?
Minimum time needed to cook 3 slices of bread on both sides using a toaster with 2 slice capacity at a time.
Cook 2 slices on one side for the first round
Cook the third slice on one side for the second round
Cook the first 2 slices on the other side for the third round
Cook the third slice on the other side for the fourth round
Total minimum time needed is 4 rounds or 2 minutes
Q4. 9 coins you have, one of the coin has lesser weight, you have a weighing balance, how many times you will have to use that to pick out the lesser weighted coin?
Weighing balance puzzle to find the lighter coin among 9 coins.
Divide the coins into 3 groups of 3 coins each
Weigh any two groups against each other
If one group is lighter, weigh two coins from that group against each other
If they are equal, the third coin is the lighter one
If they are not equal, the lighter coin is the one that weighs less
If both groups weigh the same, the lighter coin is in the third group
Weigh two coins from the third group against each other to find the l...read more
Q5. Explain about ERP, it's advantages(a software which I worked upon during my internship)
ERP is a software that integrates various business processes and functions into a single system.
ERP stands for Enterprise Resource Planning.
It helps organizations streamline their operations and improve efficiency.
Advantages of ERP include centralized data management, improved collaboration, and better decision-making.
It automates processes like inventory management, financials, human resources, and customer relationship management.
ERP provides real-time visibility into busin...read more
Q6. Q2. Guesstimate of the total number of Wagon-R cars sold in India?
Guesstimate the total number of Wagon-R cars sold in India.
Consider the total population of India and the percentage of car owners
Look at the market share of Maruti Suzuki in India
Consider the popularity of Wagon-R among small car buyers
Check the sales figures of Wagon-R in the last few years
Assume a growth rate based on the current market trends
Q7. Puzzle: There are three ants, each at a corner of an equilateral triangle. Each of them can move along any of the two sides independent of the other two ants. What is the probability that none of the ants colli...
read moreThree ants on an equilateral triangle can move along any two sides. What is the probability of no collision?
Each ant has two possible directions to move
The probability of collision is 1/3
The probability of no collision is 8/27
If a company want to get into umbrella business in your city , number of umbrella it should manufacture?
Q9. how many spherical ball of .5 inch can be placed in cube of 10 inch side and then the wastage percentage?
Approximately 8000 balls can be placed with 49% wastage.
Calculate the volume of the cube (10*10*10) and the volume of one ball (4/3*3.14*(0.5/2)^3)
Divide the volume of the cube by the volume of one ball to get the maximum number of balls that can fit
Calculate the volume of the placed balls and subtract it from the volume of the cube to get the wastage
Wastage percentage can be calculated by dividing the wastage volume by the volume of the cube and multiplying by 100
Q10. If I have to sell a new phone to a customer that is very costly, how will you approach the customer?
To approach a customer for selling a costly new phone, I would focus on highlighting the unique features, benefits, and value it offers.
Understand the customer's needs and preferences
Highlight the unique features and benefits of the phone
Emphasize the value and long-term benefits of investing in a high-quality phone
Offer flexible payment options or financing plans
Provide comparisons with other phones to showcase the superiority of the new phone
Offer a trial period or money-ba...read more
Q11. In your hostel every girl plays badminton atleast once a month. The probability of one playing badminton in 1st week is a, probability that if one doesn’t play in 1st week than she will play in 2nd week is b, p...
read moreCalculating the probability of two friends playing badminton in the same week given certain probabilities.
Calculate the probability of both playing in the first week (a*a)
Calculate the probability of both playing in the second week ((1-a)*b*(1-c))
Calculate the probability of both playing in the third week ((1-a)*(1-b)*c)
Calculate the probability of both playing in the last week ((1-a-b-c)*(1-a-b-c))
Add up all the probabilities to get the final answer
Q12. Puzzle : Consider the top face of a rubik's cube. An insect is sitting on the middle block. It can only crawl sideways not diagonally i.e for every step it has 4 options. What is the probability that it will co...
read moreCalculate probability of an insect on a Rubik's cube returning to center block after 2 moves and falling on side face on 3rd move.
The insect has 4 options for each move
To return to center block, it must move in opposite direction of its first move
Probability of returning to center block after 2 moves is 0.125
Probability of falling on side face on 3rd move is 0.5
Q13. Puzzle 1 : 2 trains start from respective stations towards each other at the same time say from Delhi & Jaipur. A bird starts with the train from delhi towards the other train & reverses its direction as soon a...
read moreThe bird travels the same distance as the sum of the distances covered by both trains.
The bird starts with one train and reverses its direction when it reaches the other train.
This process continues until the two trains collide.
The distance traveled by the bird is equal to the sum of the distances covered by both trains.
Q14. find the triangle with max area whose sides are: 300,400,500 300,400,700 ? justification
Finding the triangle with max area given sides.
Use Heron's formula to calculate the area of each triangle.
Compare the areas and select the triangle with the maximum area.
For sides 300, 400, 500, area = 60000 sq. units.
For sides 300, 400, 700, area = 72000 sq. units.
What is Group By function in SQL?
Q16. From a deck of cards, you pick out one card at a time, 3 times, with replacement. What's the probability of getting a sequence, where a sequence is defined as consecutive integers drawn in any order ?
Probability of getting a sequence of consecutive integers from a deck of cards drawn 3 times with replacement.
There are 4 possible sequences: 2-3-4, 3-4-5, 4-5-6, 5-6-7
The probability of drawing any one of these sequences is 1/52 * 1/52 * 1/52 = 1/140608
The probability of drawing any sequence (in any order) is 4/140608 = 1/35152
Q17. Write an algorithm to optimize EXL interview process.
Algorithm to optimize EXL interview process
Identify key performance indicators (KPIs) for the interview process
Use data analytics to track and analyze the KPIs
Implement automation and AI to streamline the process
Incorporate feedback from candidates and interviewers to continuously improve the process
Q18. What is the scripting language used on IBM mainframe operating systems? What are the steps in Job processing? What happens if an error is found in Job Queuing in JCL by JES? What is the Abend Code when you acce...
read moreThe scripting language used on IBM mainframe operating systems is JCL (Job Control Language).
JCL is used to define and control the execution of jobs on the mainframe.
It is a set of statements that specify the input, processing, and output requirements of a job.
JCL is used to submit batch jobs, which are sequences of programs and data that are processed without user interaction.
JCL statements are written in a specific format and are executed by the Job Entry Subsystem (JES).
Q19. Tell the smallest number which when divided by 2 gives a remainder 1, when divided by 3 gives a remainder 2, when divided by 4 gives 3 & so on till when divided by 9 gives the remainder 8.
Smallest number with remainders when divided by 2 to 9.
Find the LCM of 2 to 9.
Add 1 to the LCM until it satisfies the given remainders.
The final number is the smallest number that satisfies all the remainders.
Q20. What are inner joins, outer joins, left join
Inner joins, outer joins, and left join are types of SQL joins used to combine data from multiple tables.
Inner join returns only the matching records from both tables.
Outer join returns all records from both tables, including non-matching records.
Left join returns all records from the left table and the matching records from the right table.
Example: INNER JOIN customers ON orders.customer_id = customers.customer_id
Example: LEFT JOIN customers ON orders.customer_id = customers...read more
Q21. You are a bank owner & you need to design a new credit system. What factors will you consider before judging whether a customer should be given a loan or not
Factors to consider before giving a loan to a customer as a bank owner
Credit score and history
Income and employment status
Debt-to-income ratio
Collateral or assets
Purpose of the loan
Repayment ability
Credit utilization ratio
Legal and regulatory requirements
Q22. How would you measure model effectiveness without using any of confusion matrix metrics given the data is highly imbalanced
One way to measure model effectiveness without using confusion matrix metrics is by using area under the receiver operating characteristic curve (AUC-ROC).
Calculate the AUC-ROC score to evaluate the model's ability to distinguish between positive and negative classes.
AUC-ROC considers the entire range of classification thresholds and is insensitive to class imbalance.
Higher AUC-ROC score indicates better model performance.
Example: A model with an AUC-ROC score of 0.85 perform...read more
Q23. [Puzzle] There are 11 packets of 10 cigarettes each. 1 packet has 11 gms cigarettes and others have 10 gms cigarette. How can you identify which packet was it in one usage of electronic weighing machine
Identify the packet with 11 gms cigarettes among 11 packets of 10 gms each using an electronic weighing machine.
Weigh 1 cigarette from the first packet, 2 from the second, 3 from the third, and so on until 11 from the last packet.
Calculate the expected weight of the cigarettes in each packet based on the number of cigarettes weighed.
Compare the expected weight with the actual weight of each packet using the electronic weighing machine.
The packet with the weight difference of ...read more
Q24. Puzzle 1: Calculate the probability of a girl child when one of the two children is boy
Probability of a girl child when one of the two children is boy
Use Bayes' theorem to calculate the conditional probability
Assume equal probability of having a boy or girl child
Answer is 1/2 or 50%
Q25. Puzzle 2 : There are 25 horses & 1 racing course with 5 lanes. We don't have a stopwatch or anything to note the time. Tell the minimum number of races required to get the fastest 3 horses of the lot.
25 horses, 5 lanes, no stopwatch. Find fastest 3 horses. Minimum races required?
Divide horses into 5 groups of 5 each
Race each group, identify fastest horse from each group
Race the 5 fastest horses, identify the fastest horse
Repeat the process with the remaining 20 horses
Total races required = 7
Q26. Why analytics ? Why EXL? 1 elaborated GUESTIMATE 5 years plan Biggest achievements in life (professional and personal)
Analytics is crucial for informed decision-making and driving business growth. EXL's expertise and innovative solutions make them the ideal choice.
Analytics provides valuable insights into customer behavior, market trends, and business performance.
Data-driven decision-making is essential for staying competitive in today's fast-paced business environment.
EXL's advanced analytics capabilities and industry expertise enable them to deliver innovative solutions that drive business...read more
Q27. Puzzle: There are three jars, one of them is filled with oranges, another with apples and the third one with both apples and oranges. But all the three jars have been labeled wrong. Now you have an option to pi...
read morePick a fruit from the jar with both apples and oranges. Then deduce the contents of each jar based on the fruit you picked.
Pick a fruit from the jar labeled 'apples and oranges'
If you picked an apple, then the jar labeled 'apples' actually contains oranges and the jar labeled 'oranges' actually contains apples
If you picked an orange, then the jar labeled 'oranges' actually contains apples and the jar labeled 'apples' actually contains oranges
Q28. How to draw a dual axis chart of bar and line chart
To draw a dual axis chart of bar and line chart, use Excel or any other data visualization tool.
Create a bar chart with the data you want to display
Add a second data series and choose line chart as the chart type
Right-click on the second data series and select 'Format Data Series'
Under 'Series Options', choose 'Secondary Axis'
Adjust the formatting as needed to make the chart clear and easy to read
Q29. justification for the times of iteration required to check the number if it is prime number in c language
Iterating to check if a number is prime in C language requires justification.
Iterating through all numbers up to the square root of the number is necessary to check if it is prime.
The time complexity of this algorithm is O(sqrt(n)), which is efficient for small to medium-sized numbers.
For larger numbers, more efficient algorithms like the Miller-Rabin primality test can be used.
The number of iterations required depends on the size of the number being checked.
The iteration pro...read more
Q30. List all the relevant things if you were to float a tender for ordering tube lights if hypothetically you were the head of the engineering cell of your college ?
Relevant things to consider when floating a tender for ordering tube lights for the engineering cell of a college.
Quantity of tube lights required
Specifications of the tube lights (wattage, color temperature, length, etc.)
Budget allocated for the tender
Delivery timeline
Quality standards and certifications required
Supplier evaluation criteria
Payment terms and conditions
Warranty and after-sales support
Technical support and installation assistance
Sample tube lights for testing a...read more
Q31. Explain DML, DDL, TCL(terms used in SQL)
DML, DDL, and TCL are terms used in SQL for manipulating and managing data.
DML (Data Manipulation Language) is used for inserting, updating, and deleting data in a database.
DDL (Data Definition Language) is used for creating, altering, and dropping database objects such as tables, indexes, and views.
TCL (Transaction Control Language) is used for managing transactions in a database, including committing or rolling back changes.
Examples of DML statements include INSERT, UPDATE,...read more
Difference between Inner Join and Left join
Q33. What is the role of Visa or mastercard or AmEx on your credit cards
Visa, Mastercard, and AmEx are payment networks that process transactions made with credit cards.
Visa, Mastercard, and AmEx are payment networks that facilitate transactions between merchants, banks, and cardholders.
They provide the infrastructure for credit card transactions to occur, including authorization, clearing, and settlement.
Visa and Mastercard are accepted at most merchants worldwide, while AmEx is more exclusive and typically accepted at higher-end establishments....read more
Q34. If you start a startup of selling books to IITK students through e-commerce what will be the annual demand you can expect from IITK students?
The annual demand for selling books to IITK students through e-commerce depends on various factors such as the number of students, their course curriculum, and their reading habits.
The demand can be estimated by conducting a survey among the students to understand their reading habits and preferences.
The demand can also be influenced by the availability of books in the campus library and bookstores.
The demand may vary depending on the academic calendar, such as the start of a...read more
Q35. What can be done to reduce errors and how can SLA be maintained
To reduce errors and maintain SLA, proper training, clear communication, and regular quality checks are necessary.
Provide comprehensive training to employees on processes and procedures
Ensure clear communication between team members and with clients
Implement regular quality checks to identify and address errors
Use technology and automation to streamline processes and reduce human error
Establish contingency plans to address potential issues and minimize impact on SLA
Encourage ...read more
Q36. Maximum number of runs a opener batsman can score in a T20 match if he stays till end?
The maximum number of runs an opener batsman can score in a T20 match if he stays till the end is 240.
Assuming the opener faces all 120 balls, he can score a maximum of 240 runs.
This is calculated by hitting a six on every ball.
However, this is practically impossible and has never been achieved in a T20 match.
Q37. If I have to install a light pole on the road, what should its height be? (use logic)
The height of a light pole on the road should be determined based on factors such as road width, lighting requirements, and safety regulations.
Consider the width of the road and the distance between light poles to ensure adequate lighting coverage.
Take into account the height of nearby buildings or structures that may obstruct the light.
Adhere to safety regulations and guidelines regarding the minimum and maximum height of light poles.
Consider the type of lighting fixtures be...read more
Q38. What idea did you come up with to reduce unallocated funds
I proposed implementing a budget tracking system to monitor and control unallocated funds.
Suggested implementing a budget tracking system to monitor expenses
Proposed regular reviews of budget to identify areas of overspending
Suggested reallocating funds from low-priority projects to high-priority ones
Proposed implementing a system to track and analyze spending patterns
Suggested involving department heads in budget planning and decision-making
Q39. Why there are only 30 rows in airplane? What if number of rows are changed, how will it affect our profits?
The number of rows in an airplane affects profits.
The number of rows determines the seating capacity of the airplane.
More rows can lead to higher profits if the demand for tickets is high.
Fewer rows can lead to lower profits if the demand for tickets is low.
The number of rows also affects the weight and fuel consumption of the airplane.
Changing the number of rows may require adjustments in pricing and seating arrangements.
Q40. What is the account? The system of recording and sumerizing business and financial transactions and analyzing, verifying and reporting the results.
An account is a system of recording and summarizing financial transactions.
Accounts are used to keep track of financial transactions in a business.
They are used to record and summarize transactions such as sales, purchases, and expenses.
Accounts are important for financial reporting and analysis.
Examples of accounts include accounts payable, accounts receivable, and general ledger accounts.
Q41. If I have to install an elevator in the Sabarmati building, give me 5-6 factors that I need to consider
Factors to consider when installing an elevator in the Sabarmati building
Building regulations and permits
Structural integrity of the building
Available space and layout
Electrical and mechanical requirements
Safety features and emergency protocols
Maintenance and servicing
Q42. Tell some places/fields around you where you think analytics is been used
Analytics is used in various fields around me
Marketing and advertising
Finance and banking
Healthcare and medicine
Sports and fitness
Transportation and logistics
Q43. if you are changing domain , why you want to change domain?
I am changing domain to explore new opportunities and challenges.
I want to broaden my skill set and gain new experiences.
I am looking for a more challenging role that aligns with my career goals.
I am interested in exploring a different industry or sector.
I want to work with a different team or company culture.
I am seeking better work-life balance or location.
Example: I am currently working in the IT industry, but I want to transition to finance because I have always been inte...read more
Q44. An aviation company wants to start a flight between Mumbai and Jaipur. What all things should it keep in mind?
An aviation company planning a flight between Mumbai and Jaipur should consider various factors.
Analyze the demand for the route
Check for competition and their pricing
Evaluate the feasibility of the route
Consider the availability of airport slots
Assess the infrastructure and facilities at both airports
Ensure compliance with regulatory requirements
Develop a marketing strategy to promote the new route
Q45. How many lines can be constructed using 5 non collinear points and 3 collinear points?
The number of lines that can be constructed using 5 non-collinear points and 3 collinear points.
The 3 collinear points will form 3 lines.
Each of the 5 non-collinear points can be connected to the other 4 points to form 20 lines.
However, any line passing through one of the collinear points will be redundant.
Therefore, the total number of lines that can be constructed is 20 - 3 = 17.
Q46. How would you estimate the distance between Delhi and Beijing?
The distance between Delhi and Beijing can be estimated using various methods.
One can use the Haversine formula to calculate the distance based on the latitude and longitude of the two cities.
Another method is to use online distance calculators that take into account the flight distance and driving distance.
The distance can also be estimated by looking at the approximate time it takes to travel between the two cities by air or road.
Factors such as the mode of transportation, ...read more
Q47. You have two hour glasses. One which can measure 4 minutes. Other which can measure 7 minutes. How to calculate 9 minutes
Use both hourglasses to measure 9 minutes
Start both hourglasses at the same time
When the 4-minute hourglass runs out, flip it over
When the 7-minute hourglass runs out, flip it over
When the 4-minute hourglass runs out for the second time, 9 minutes have passed
Q48. Cut cake into 8 pieces by slicing it just 3 times
Cut cake into 8 pieces with 3 slices
Make two horizontal cuts to get 4 equal pieces
Stack the 4 pieces and make two vertical cuts
You now have 8 equal pieces of cake
Q49. What is group by fucation in sql?
GROUP BY is a SQL clause used to group rows based on a column and perform aggregate functions on them.
Used to group rows based on a column
Aggregate functions can be performed on the grouped rows
Used with SELECT statement
Commonly used with COUNT, SUM, AVG functions
Helps in data analysis and reporting
Q50. Difference between proc means and proc summary?
Proc means and proc summary are SAS procedures used for summarizing data, but with slight differences.
Proc means provides more detailed statistics like standard deviation, minimum and maximum values, while proc summary only provides basic statistics like mean and sum.
Proc means can handle missing values, while proc summary cannot.
Proc summary can create multiple output datasets, while proc means only creates one.
Both procedures can be used for numeric and character variables....read more
Q51. How do you ensure that retrieval in RAG give the correct documents? Explain any project involving generative AI.
Ensuring correct document retrieval in RAG and discussing a project involving generative AI.
Utilize a combination of retrieval and generative models in RAG to ensure correct document retrieval.
Implement techniques such as fine-tuning the models, using diverse training data, and optimizing hyperparameters.
Regularly evaluate the performance of the models through metrics like precision, recall, and F1 score.
Provide examples of projects where generative AI was used, such as creat...read more
Q52. By how much precent flipkart should increase its inventory of mobile phones during Diwali season?
The percentage increase in inventory of mobile phones for Flipkart during Diwali season depends on various factors such as demand, competition, and sales data.
Flipkart should analyze the demand for mobile phones during Diwali season based on previous year's sales data.
They should also consider the competition and the inventory levels of their competitors.
Based on these factors, they can decide on the percentage increase in inventory of mobile phones.
For example, if the demand...read more
Q53. What is big data
Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.
Big data involves the collection, storage, and analysis of massive amounts of data
It requires advanced technologies and tools to process and make sense of the data
Examples of big data include social media data, sensor data, and financial market data
Q54. What are different types of Records ?
Different types of records include audio records, medical records, criminal records, financial records, and academic records.
Audio records: Recordings of sound or music.
Medical records: Documents containing a patient's medical history and treatment information.
Criminal records: Records of a person's criminal history and convictions.
Financial records: Documents related to an individual or organization's financial transactions and accounts.
Academic records: Records of a student...read more
Q55. Estimate the no. of Rs. 1000 notes in India before demonetization
Estimating the number of Rs. 1000 notes in India before demonetization.
The total currency in circulation before demonetization was around Rs. 17.77 lakh crore.
Rs. 1000 notes constituted around 39% of the total currency in circulation.
Therefore, the estimated number of Rs. 1000 notes in India before demonetization was around 6.92 billion.
However, this is just an estimate and the actual number may vary.
Q56. Derivatives Difference between reserve and provision Reasons for intercompany differences Deferred tax meaning Way of creating deferred tax assets and liability How we can write-off deferred tax asset
The difference between reserve and provision, reasons for intercompany differences, deferred tax meaning, creating deferred tax assets and liabilities, and writing off deferred tax assets.
Reserve is an appropriation of profits for a specific purpose, while provision is a charge against profits for an anticipated expense.
Intercompany differences can arise due to different accounting policies, timing differences, or errors in consolidation.
Deferred tax refers to the future tax ...read more
Q57. What is calculated fields (in microsoft excel)
Calculated fields in Microsoft Excel are formulas created by users to perform calculations on data in a table.
Calculated fields are created using formulas
They can perform calculations on data in a table
Examples include summing up columns or calculating averages
Calculated fields are dynamic and update automatically when the data changes
Q58. There is table which holds details of matches played between the countries in first 2 columns and who won the match in 3rd column. write a query to get no. of matches played by each team and no. of matches won ...
read moreQuery to get number of matches played and won by each team from a table of match details.
Use GROUP BY clause to group the data by team name.
Use COUNT() function to get the number of matches played by each team.
Use SUM() function with a condition to get the number of matches won by each team.
Q59. [Guestimate] What is the target number of customers for high-end men's wallet in Delhi?
The target number of customers for high-end men's wallet in Delhi depends on various factors such as market demand, competition, and pricing.
Market research and analysis can help determine the potential customer base
Competition from other high-end wallet brands can affect the target number
Pricing strategy can also impact the target number of customers
Factors such as disposable income and fashion trends can also play a role
Target number can range from a few hundred to thousand...read more
Q60. Differences between inner join and left join?
Inner join returns only matching rows from both tables while left join returns all rows from left table and matching rows from right table.
Inner join is used to retrieve data that exists in both tables based on a common column.
Left join is used to retrieve all data from the left table and matching data from the right table.
Inner join excludes non-matching rows from both tables while left join includes all rows from the left table.
Inner join is faster than left join as it invo...read more
Q61. How do you resolve the issues faced in processing PO based invoices?
Issues in processing PO based invoices can be resolved by implementing a streamlined process and ensuring proper communication with vendors.
Establish clear guidelines for PO creation and invoice submission
Ensure timely communication with vendors regarding any discrepancies or missing information
Implement automated systems for invoice processing and approval
Regularly review and analyze the process to identify areas for improvement
Train employees on the importance of following ...read more
Q62. How many Ice Cream Sales are in the Delhi region?
The number of ice cream sales in Delhi region is not available.
There is no available data on the number of ice cream sales in Delhi region.
It is difficult to estimate the exact number of ice cream sales in Delhi region without proper data.
Factors like season, location, and competition can affect the number of ice cream sales in Delhi region.
Q63. Estimate the no. of people participated in Delhi Marathon
The estimated number of people who participated in the Delhi Marathon is...
The number of registered participants can be used as a starting point
Factors such as weather conditions, location, and popularity of the event can affect the turnout
Previous years' participation numbers can also be used as a reference
Media coverage and social media activity can provide insights into the event's popularity
An official statement from the organizers can provide an accurate count
Q64. What is Blue score in Regression
Blue score is not a term used in regression analysis.
Blue score is not a standard term in regression analysis
It is possible that the interviewer meant to ask about another metric such as R-squared or mean squared error
Without further context, it is difficult to provide a more specific answer
Q65. Explan PV Ratio and difference between accrual and prepaid expense.
PV ratio is the ratio of contribution to sales. Accrual expenses are recognized but not yet paid, while prepaid expenses are paid but not yet recognized.
PV ratio is calculated by dividing contribution by sales.
It helps in determining the break-even point and the impact of changes in sales volume on profit.
Accrual expenses are expenses that have been incurred but not yet paid, such as salaries or interest.
Prepaid expenses are expenses that have been paid in advance but not yet...read more
Q66. What can Flipkart do to improve its rural presence?
Flipkart can improve its rural presence by expanding its logistics network, offering localized products, and providing vernacular language support.
Expand logistics network to reach remote areas
Offer localized products based on regional preferences
Provide vernacular language support for better communication
Partner with local businesses to establish trust and credibility
Offer affordable pricing and easy payment options
Organize awareness campaigns to educate rural customers abou...read more
Q67. What is VLOOKUP & where you use it
VLOOKUP is a function in Excel used to search for a specific value in a table and return a corresponding value.
VLOOKUP stands for Vertical Lookup
It is used to find a specific value in a table and return a corresponding value from the same row
It requires a lookup value, table array, column index number, and range lookup
Example: VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
It is commonly used in financial analysis, data management, and reporting
Q68. How to cut a cake in 8 equal parts
Cut the cake in half, then cut each half in half again. Repeat once more to get 8 equal parts.
Use a long, sharp knife to make clean cuts.
Start by cutting the cake in half vertically.
Then cut each half in half horizontally.
Repeat the process once more to get 8 equal parts.
Use a cake divider or toothpicks to mark where to cut for even slices.
Q69. Accounts two parties? Short term goal Long term goal
Accounts payable involves two parties: the company and its vendors. My short term goal is to learn the company's payment processes and build strong relationships with vendors. My long term goal is to streamline the accounts payable process and reduce costs.
Accounts payable involves two parties: the company and its vendors
Short term goal is to learn the company's payment processes and build strong relationships with vendors
Long term goal is to streamline the accounts payable p...read more
Q70. Guesstimate - How many pen stands can you fit in a Boeing 747?
Guesstimate the number of pen stands that can fit in a Boeing 747.
Calculate the volume of a pen stand
Calculate the volume of the Boeing 747
Divide the volume of the Boeing 747 by the volume of a pen stand
Consider the available space and potential obstructions inside the plane
Q71. What are the potential customers for a new credit card in chennai?
Potential customers for a new credit card in Chennai include working professionals, business owners, students, and individuals with high income.
Working professionals who require a credit card for their daily expenses and transactions.
Business owners who need a credit card for their business expenses and to manage cash flow.
Students who may need a credit card for educational expenses and to build credit history.
Individuals with high income who can afford premium credit cards a...read more
Q72. if you have knowledge of excel tell me difference between hlookup,vlookup and xlookup?
HLOOKUP searches for a value in the top row of a table, VLOOKUP searches for a value in the first column of a table, and XLOOKUP is a more versatile version of VLOOKUP and HLOOKUP.
HLOOKUP searches for a value in the top row of a table and returns a value in the same column from a specified row.
VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
XLOOKUP is a more versatile version of VLOOKUP and HLOOKUP, allow...read more
Q73. What issues do you face while processing the PO invoice?
Issues faced while processing PO invoices
Matching PO details with invoice details
Ensuring correct pricing and quantities
Verifying vendor information
Handling discrepancies and exceptions
Ensuring timely payment to vendors
Q74. What is working capital. Why working capital negative
Working capital is the measure of a company's liquidity and operational efficiency. It represents the difference between current assets and current liabilities.
Working capital is the amount of money available to a company for its day-to-day operations.
It is calculated by subtracting current liabilities from current assets.
Positive working capital indicates that a company has enough assets to cover its short-term liabilities.
Negative working capital means that a company's curr...read more
Q75. how did you identify improvement oppurtunities in process
I identified improvement opportunities in process by analyzing data, observing the process, and gathering feedback from stakeholders.
Analyze data to identify bottlenecks, inefficiencies, and areas for improvement
Observe the process to identify areas where steps can be eliminated or streamlined
Gather feedback from stakeholders to identify pain points and areas for improvement
Use process mapping and flowcharting to visualize the process and identify areas for improvement
Benchma...read more
Q76. What accordingly to you is digital transformations, how it is different from automation ?
Digital transformation is the integration of digital technology into all areas of a business, while automation is the use of technology to perform tasks without human intervention.
Digital transformation involves a fundamental change in how a business operates, while automation is focused on streamlining specific processes.
Digital transformation is a long-term strategy that requires a cultural shift, while automation is a short-term solution to improve efficiency.
Digital trans...read more
Q77. What is an invoice and what can we see in a invoice
An invoice is a document that lists the products or services provided by a vendor and the amount due for payment.
An invoice includes the vendor's name and contact information
It lists the products or services provided and their prices
It includes the total amount due and any applicable taxes or discounts
It may also include payment terms and due dates
Examples of invoices include bills from utility companies, invoices from suppliers, and receipts from online purchases
Q78. What is the insurance
Insurance is a financial product that provides protection against specified risks in exchange for payment of a premium.
Insurance is a contract between an individual or organization and an insurance company.
The individual or organization pays a premium to the insurance company in exchange for coverage against specific risks.
Types of insurance include health insurance, life insurance, auto insurance, and property insurance.
Insurance helps individuals and organizations manage ri...read more
Q79. What you know about US insurance industry ?
The US insurance industry is a multi-billion dollar industry that provides coverage for various risks and liabilities.
The industry is regulated at the state level
Major types of insurance include health, auto, home, and life insurance
The Affordable Care Act (ACA) has had a significant impact on the health insurance market
Insurance companies use actuarial science to determine premiums and assess risk
The industry is highly competitive with many large and small players
Natural dis...read more
Q80. What is debit note and credit note
Debit note and credit note are accounting documents used to record adjustments in financial transactions.
Debit note is issued by a buyer to a seller to request a credit for overcharged or returned goods/services.
Credit note is issued by a seller to a buyer to provide a credit for undercharged or faulty goods/services.
Debit note increases the buyer's accounts payable and decreases the seller's accounts receivable.
Credit note decreases the buyer's accounts payable and increases...read more
Q81. How many books are sold at jalandhar railway station daily?
It is not possible to accurately determine the number of books sold at Jalandhar railway station daily without proper data analysis.
There is no publicly available data on the number of books sold at Jalandhar railway station.
The number of books sold can vary greatly depending on factors such as time of day, day of the week, and season.
One would need to conduct a thorough analysis of sales data to determine an accurate estimate of the number of books sold daily.
Q82. What is Hypotheses concepts and how to use it? What is value stream mapping? Detail explanation of current project?
Hypotheses concepts are assumptions made to test a theory. Value stream mapping is a tool to visualize and improve processes.
Hypotheses concepts are used in scientific research to test a theory by making assumptions and testing them through experiments.
Value stream mapping is a lean management tool used to visualize and analyze the flow of materials and information in a process.
Current project details are not available.
Q83. Use of Read only Grid and Editable Grid ?
Read only grid is used to display data that cannot be edited, while editable grid allows users to modify data.
Read only grid is used to display data that cannot be edited
Editable grid allows users to modify data
Read only grid is commonly used for displaying reference data or historical records
Editable grid is used for data entry or updating existing records
Both grids can be customized with different column types, sorting, filtering, and pagination
Q84. Guesstimate- how many seats are there in a plane and train
The number of seats in a plane and train can vary depending on the size and type of the aircraft or train.
Planes can have anywhere from 20 seats in a small private jet to over 600 seats in a large commercial airliner like the Airbus A380.
Trains can have a few dozen seats in a small commuter train to hundreds of seats in a high-speed train like the Shinkansen in Japan.
The number of seats in a plane or train also depends on the class configuration (economy, business, first clas...read more
Q85. Tell me the difference between r square and adjusted r square
R square measures the proportion of variance explained by the independent variables, while adjusted R square penalizes for adding unnecessary variables.
R square increases as more variables are added, even if they are not significant
Adjusted R square increases only if the added variable improves the model more than would be expected by chance
Adjusted R square is always lower than R square
Adjusted R square is a better measure of the goodness of fit of a regression model
Q86. Usage analytics to increase outreach. How ?
Usage analytics can increase outreach by providing insights on user behavior and preferences.
Analyze user data to identify patterns and trends
Use analytics tools to track user engagement and conversion rates
Segment users based on their behavior and preferences
Tailor marketing campaigns and outreach strategies to target specific user segments
Monitor the effectiveness of outreach efforts through analytics metrics
Continuously optimize outreach strategies based on analytics insig...read more
Q87. Number of guitars in n trichy
The question is unclear and lacks context. More information is needed to provide an accurate answer.
What is the context of the question? Is it related to a specific store or location?
What is the timeframe for the question? Is it asking for current inventory or historical data?
Are there any assumptions that can be made based on the information given?
Without additional information, it is impossible to provide an accurate answer.
Q88. How does a credit card work
A credit card allows you to borrow money from a bank or financial institution to make purchases.
Credit card issuer gives you a line of credit based on your creditworthiness
You can use the card to make purchases up to your credit limit
You have to pay back the borrowed amount with interest
If you don't pay the full amount, interest is charged on the remaining balance
Late payments or exceeding credit limit can result in fees and damage to credit score
Q89. What is the difference between App studio and Dev studio in Pega PRPC
App studio is used for building user interfaces and configuring applications, while Dev studio is used for developing and customizing application logic.
App studio is primarily used by business users and non-technical users to design and configure user interfaces and application behavior.
Dev studio is used by developers and technical users to write and customize application logic using Pega's proprietary programming language, PegaRULES.
App studio provides a visual interface fo...read more
Q90. Best Practices to create Process Model
Best practices for creating a process model in Appian
Clearly define the process objectives and scope
Break down the process into smaller, manageable tasks
Use descriptive and meaningful activity names
Ensure proper sequencing of activities
Include decision points and conditional flows
Design for reusability and modularity
Consider exception handling and error management
Collaborate with stakeholders for feedback and validation
Document the process model for future reference
Q91. How will you add and remove columns from pandas dataframe.
To add or remove columns from a pandas dataframe, we can use the 'drop' and 'insert' methods.
To remove a column, we can use the 'drop' method with the 'axis' parameter set to 1.
To add a column, we can simply assign a new column to the dataframe with a name and values.
To insert a column at a specific position, we can use the 'insert' method with the index and column name.
We can also rename columns using the 'rename' method.
Q92. What processes have you worked in Finance Transformation of captives?
I have worked on finance transformation processes for captives by implementing automation, streamlining workflows, and optimizing financial reporting.
Implemented automation to reduce manual effort and increase efficiency
Streamlined workflows to eliminate redundancies and improve productivity
Optimized financial reporting to provide accurate and timely information for decision-making
Collaborated with cross-functional teams to ensure successful implementation
Provided training an...read more
Q93. What are the difference between List and Tuples?
Lists are mutable while Tuples are immutable.
Lists use square brackets [] while Tuples use parentheses ().
Lists can be modified while Tuples cannot be modified.
Lists are used for homogenous items while Tuples are used for heterogenous items.
Lists are slower than Tuples.
Example of List: my_list = [1, 2, 3]
Example of Tuple: my_tuple = (1, 'hello', 3.4)
Q94. what is the devops? how both python is used? what can be done for 3 tier architecture
DevOps is a software development approach that emphasizes collaboration, automation, and monitoring throughout the software development lifecycle.
DevOps is a combination of development and operations that aims to improve the speed and quality of software delivery.
Python is a popular language for DevOps tasks such as automation, configuration management, and testing.
In a 3-tier architecture, the presentation, application, and data layers are separated to improve scalability, f...read more
Q95. What are the components of knee and hip?
The knee and hip are joints in the human body.
The knee joint is made up of the femur, tibia, and patella bones.
The hip joint is made up of the femur and pelvis bones.
Both joints are surrounded by ligaments, tendons, and muscles that provide stability and movement.
The knee joint also has cartilage and synovial fluid that help with shock absorption and lubrication.
The hip joint has a cartilage lining and a synovial membrane that produces fluid for lubrication.
Q96. Whats is the general entry for bank interest
The general entry for bank interest is to debit the bank account and credit the interest income account.
Debit bank account
Credit interest income account
Interest income is recorded as revenue
Bank account is reduced by the amount of interest paid
Example: Debit Bank Account $100, Credit Interest Income Account $100
Q97. What is Regression Testing What is integration Testing Smoke Testing Black box Technic API Validation and verification Alpha testing API method Function Testing
Regression testing is retesting of previously tested software to ensure that changes made to the software have not affected its existing functionality.
Regression testing is done to ensure that changes made to the software have not introduced new bugs or affected its existing functionality.
It is usually done after a new feature or bug fix is implemented.
Examples include running a test suite after a code change or after a new release of the software.
Integration testing is testi...read more
Q98. Which embedding model and similarity search algorithm did you used?
I used Word2Vec embedding model and cosine similarity algorithm for similarity search.
Word2Vec embedding model was used to convert words into numerical vectors.
Cosine similarity algorithm was used to measure the similarity between vectors.
Example: Word2Vec model trained on a large corpus of text data, cosine similarity used to find similar words or documents.
Q99. Case study - Strategy to sell credit cards to Chennai population
Strategy to sell credit cards to Chennai population
Conduct market research to understand the needs and preferences of the Chennai population
Offer attractive rewards and benefits such as cashback, discounts, and reward points
Partner with local businesses to offer exclusive deals and discounts to credit card holders
Create targeted marketing campaigns in local languages and use social media to reach a wider audience
Provide excellent customer service and support to build trust an...read more
Q100. What do you think is better- loan or credit?
It depends on the purpose and individual's financial situation.
Loan is better for long-term investments like buying a house or car.
Credit is better for short-term expenses like paying bills or emergencies.
Interest rates and repayment terms should be carefully considered.
Individual's credit score and financial stability also play a role in decision making.
Top HR Questions asked in null
Interview Process at null
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month