Add office photos
Engaged Employer

EXL Service

3.8
based on 6.7k Reviews
Filter interviews by

300+ Interview Questions and Answers

Updated 26 Nov 2024
Popular Designations

Q1. If I have 333 digits to number pages of a book, How many pages can I number ?

Ans.

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.

View 7 more answers

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 more
Ans.

Drawing 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

Add your answer

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 ?

Ans.

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

View 2 more answers

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?

Ans.

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

View 1 answer
Discover null interview dos and don'ts from real experiences

Q5. Explain about ERP, it's advantages(a software which I worked upon during my internship)

Ans.

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

View 1 answer

Q6. Q2. Guesstimate of the total number of Wagon-R cars sold in India?

Ans.

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

Add your answer
Are these interview questions helpful?

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 more
Ans.

Three 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

View 2 more answers
Q8. Guesstimate Question

If a company want to get into umbrella business in your city , number of umbrella it should manufacture?

Add your answer
Share interview questions and help millions of jobseekers 🌟

Q9. how many spherical ball of .5 inch can be placed in cube of 10 inch side and then the wastage percentage?

Ans.

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

Add your answer

Q10. If I have to sell a new phone to a customer that is very costly, how will you approach the customer?

Ans.

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

View 1 answer

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 more
Ans.

Calculating 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

Add your 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 more
Ans.

Calculate 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

Add your answer

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 more
Ans.

The 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.

Add your answer

Q14. find the triangle with max area whose sides are: 300,400,500 300,400,700 ? justification

Ans.

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.

Add your answer
Q15. DBMS Question

What is Group By function in SQL?

Add your answer

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 ?

Ans.

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

Add your answer

Q17. Write an algorithm to optimize EXL interview process.

Ans.

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

Add your answer

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 more
Ans.

The 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).

Add your answer

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.

Ans.

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.

Add your answer

Q20. What are inner joins, outer joins, left join

Ans.

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

Add your answer

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

Ans.

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

View 1 answer

Q22. How would you measure model effectiveness without using any of confusion matrix metrics given the data is highly imbalanced

Ans.

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

View 1 answer

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

Ans.

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

Add your answer

Q24. Puzzle 1: Calculate the probability of a girl child when one of the two children is boy

Ans.

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%

Add your answer

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.

Ans.

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

Add your answer

Q26. Why analytics ? Why EXL? 1 elaborated GUESTIMATE 5 years plan Biggest achievements in life (professional and personal)

Ans.

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

Add your answer

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 more
Ans.

Pick 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

Add your answer

Q28. How to draw a dual axis chart of bar and line chart

Ans.

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

Add your answer

Q29. justification for the times of iteration required to check the number if it is prime number in c language

Ans.

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

Add your answer

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 ?

Ans.

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

Add your answer

Q31. Explain DML, DDL, TCL(terms used in SQL)

Ans.

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

View 1 answer
Q32. DBMS Question

Difference between Inner Join and Left join

Add your answer

Q33. What is the role of Visa or mastercard or AmEx on your credit cards

Ans.

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

Add your answer

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?

Ans.

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

Add your answer

Q35. What can be done to reduce errors and how can SLA be maintained

Ans.

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

Add your answer

Q36. Maximum number of runs a opener batsman can score in a T20 match if he stays till end?

Ans.

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.

Add your answer

Q37. If I have to install a light pole on the road, what should its height be? (use logic)

Ans.

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

Add your answer

Q38. What idea did you come up with to reduce unallocated funds

Ans.

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

Add your answer

Q39. Why there are only 30 rows in airplane? What if number of rows are changed, how will it affect our profits?

Ans.

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.

Add your answer

Q40. What is the account? The system of recording and sumerizing business and financial transactions and analyzing, verifying and reporting the results.

Ans.

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.

Add your answer

Q41. If I have to install an elevator in the Sabarmati building, give me 5-6 factors that I need to consider

Ans.

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

Add your answer

Q42. Tell some places/fields around you where you think analytics is been used

Ans.

Analytics is used in various fields around me

  • Marketing and advertising

  • Finance and banking

  • Healthcare and medicine

  • Sports and fitness

  • Transportation and logistics

Add your answer

Q43. if you are changing domain , why you want to change domain?

Ans.

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

View 2 more answers

Q44. An aviation company wants to start a flight between Mumbai and Jaipur. What all things should it keep in mind?

Ans.

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

Add your answer

Q45. How many lines can be constructed using 5 non collinear points and 3 collinear points?

Ans.

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.

Add your answer

Q46. How would you estimate the distance between Delhi and Beijing?

Ans.

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

Add your answer

Q47. You have two hour glasses. One which can measure 4 minutes. Other which can measure 7 minutes. How to calculate 9 minutes

Ans.

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

Add your answer

Q48. Cut cake into 8 pieces by slicing it just 3 times

Ans.

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

Add your answer

Q49. What is group by fucation in sql?

Ans.

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

Add your answer

Q50. Difference between proc means and proc summary?

Ans.

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

Add your answer

Q51. How do you ensure that retrieval in RAG give the correct documents? Explain any project involving generative AI.

Ans.

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

Add your answer

Q52. By how much precent flipkart should increase its inventory of mobile phones during Diwali season?

Ans.

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

Add your answer

Q53. What is big data

Ans.

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

Add your answer

Q54. What are different types of Records ?

Ans.

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

View 2 more answers

Q55. Estimate the no. of Rs. 1000 notes in India before demonetization

Ans.

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.

Add your answer

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

Ans.

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

Add your answer

Q57. What is calculated fields (in microsoft excel)

Ans.

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

Add your answer

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 more
Ans.

Query 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.

Add your answer

Q59. [Guestimate] What is the target number of customers for high-end men's wallet in Delhi?

Ans.

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

Add your answer

Q60. Differences between inner join and left join?

Ans.

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

Add your answer

Q61. How do you resolve the issues faced in processing PO based invoices?

Ans.

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

Add your answer

Q62. How many Ice Cream Sales are in the Delhi region?

Ans.

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.

Add your answer

Q63. Estimate the no. of people participated in Delhi Marathon

Ans.

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

Add your answer

Q64. What is Blue score in Regression

Ans.

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

View 1 answer

Q65. Explan PV Ratio and difference between accrual and prepaid expense.

Ans.

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

View 1 answer

Q66. What can Flipkart do to improve its rural presence?

Ans.

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

Add your answer

Q67. What is VLOOKUP & where you use it

Ans.

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

Add your answer

Q68. How to cut a cake in 8 equal parts

Ans.

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.

Add your answer

Q69. Accounts two parties? Short term goal Long term goal

Ans.

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

Add your answer

Q70. Guesstimate - How many pen stands can you fit in a Boeing 747?

Ans.

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

Add your answer

Q71. What are the potential customers for a new credit card in chennai?

Ans.

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

Add your answer

Q72. if you have knowledge of excel tell me difference between hlookup,vlookup and xlookup?

Ans.

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

Add your answer

Q73. What issues do you face while processing the PO invoice?

Ans.

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

Add your answer

Q74. What is working capital. Why working capital negative

Ans.

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

View 2 more answers

Q75. how did you identify improvement oppurtunities in process

Ans.

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

Add your answer

Q76. What accordingly to you is digital transformations, how it is different from automation ?

Ans.

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

Add your answer

Q77. What is an invoice and what can we see in a invoice

Ans.

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

Add your answer

Q78. What is the insurance

Ans.

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

View 2 more answers

Q79. What you know about US insurance industry ?

Ans.

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

Add your answer

Q80. What is debit note and credit note

Ans.

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

View 1 answer

Q81. How many books are sold at jalandhar railway station daily?

Ans.

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.

Add your answer

Q82. What is Hypotheses concepts and how to use it? What is value stream mapping? Detail explanation of current project?

Ans.

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.

Add your answer

Q83. Use of Read only Grid and Editable Grid ?

Ans.

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

View 1 answer

Q84. Guesstimate- how many seats are there in a plane and train

Ans.

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

Add your answer

Q85. Tell me the difference between r square and adjusted r square

Ans.

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

Add your answer

Q86. Usage analytics to increase outreach. How ?

Ans.

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

Add your answer

Q87. Number of guitars in n trichy

Ans.

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.

Add your answer

Q88. How does a credit card work

Ans.

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

Add your answer

Q89. What is the difference between App studio and Dev studio in Pega PRPC

Ans.

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

View 1 answer

Q90. Best Practices to create Process Model

Ans.

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

View 1 answer

Q91. How will you add and remove columns from pandas dataframe.

Ans.

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.

Add your answer

Q92. What processes have you worked in Finance Transformation of captives?

Ans.

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

Add your answer

Q93. What are the difference between List and Tuples?

Ans.

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)

Add your answer

Q94. what is the devops? how both python is used? what can be done for 3 tier architecture

Ans.

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

Add your answer

Q95. What are the components of knee and hip?

Ans.

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.

Add your answer

Q96. Whats is the general entry for bank interest

Ans.

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

Add your answer

Q97. What is Regression Testing What is integration Testing Smoke Testing Black box Technic API Validation and verification Alpha testing API method Function Testing

Ans.

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

Add your answer

Q98. Which embedding model and similarity search algorithm did you used?

Ans.

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.

Add your answer

Q99. Case study - Strategy to sell credit cards to Chennai population

Ans.

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

Add your answer

Q100. What do you think is better- loan or credit?

Ans.

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.

Add your answer
1
2
3
4
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at null

based on 259 interviews in the last 1 year
Interview experience
4.0
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

3.9
 • 518 Interview Questions
3.8
 • 356 Interview Questions
3.7
 • 262 Interview Questions
3.8
 • 139 Interview Questions
3.9
 • 132 Interview Questions
View all
Top EXL Service Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter