Televisory Interview Questions and Answers

Q1. Excel 5-6 questions. 4 sheets with some common id.
Add your answer
Q2. Guesstimate of number of tea sold in Delhi
Ans. 
Approximately 10 million cups of tea are sold in Delhi daily.
• Consider population of Delhi (approximately 20 million)

• Assume 50% of population consumes tea daily

• On average, a person consumes 2 cups of tea per day

• Total tea sold = 20 million * 0.5 * 2 = 10 million cups
Answered by AI
Add your answer
Q3. Questions of basic Tableau and excel formulas
Add your answer

Gave an assignment of calculating number of tea sold outside india for Vadham tea.

Asked a guesstimate. This was an easy guesstimate but recruiter was not paying attention, was busy in mobile.

Q1. Estimate number of burgers sold by one burger Outlet in your city.
Ans. 
The number of burgers sold by a burger outlet in a city can vary based on factors like location, menu offerings, pricing, and customer demand.
• Consider the population of the city and the popularity of the outlet.

• Analyze the outlet's menu offerings and pricing compared to competitors.

• Take into account any special promotions or events that may impact sales.

• Look at historical sales data if available.

• Interview employees or
Answered by AI
Add your answer

Q1. Estimate transportation cost for raw materials.
Ans. 
Transportation cost for raw materials can be estimated based on distance, mode of transportation, quantity, and current market rates.
• Consider the distance between the supplier and the manufacturing facility

• Take into account the mode of transportation (road, rail, sea, air)

• Calculate the quantity of raw materials being transported

• Research current market rates for transportation services

• Factor in any additional costs such
Answered by AI
Add your answer

Q1. Asked about past experience
Add your answer
Q2. Some guesstimate question
Add your answer

Q1. Securitisation and how it works.
Ans. 
Securitisation is the process of pooling various types of debt and selling them as securities to investors.
• Securitisation involves bundling together various types of debt, such as mortgages, auto loans, or credit card debt.

• These debts are then sold to a special purpose vehicle (SPV) which issues securities backed by the cash flows from the underlying assets.

• Investors purchase these securities and receive payments based...read more
Answered by AI
View 1 more answer
Q2. Financial Ratios and how they work and what is a good number to have.
Ans. 
Financial ratios are tools used to evaluate a company's financial performance and health.
• Financial ratios are calculated using data from a company's financial statements.

• They help investors and analysts assess a company's profitability, liquidity, efficiency, and solvency.

• A good number for a financial ratio can vary depending on the industry and company size.

• For example, a current ratio of 2 or higher is generally cons...read more
Answered by AI
Add your answer
Q3. Random number crunching based on some scenario that needs you to make assumptions and get an answer
Add your answer
Q4. How an Excel function works. (Vlookup, Hlookup, Xlookup, IF/AND/OR)
Ans. 
Excel functions like Vlookup, Hlookup, Xlookup, IF/AND/OR are used for data lookup and logical operations.
• Vlookup: Searches for a value in the first column of a table and returns a value in the same row from a specified column.

• Hlookup: Similar to Vlookup but searches for a value in the first row of a table.

• Xlookup: A more versatile version of Vlookup and Hlookup that can search both vertically and horizontally.

• IF: Retu...read more
Answered by AI
Add your answer

Q1. Personal Questions.
Add your answer
Q2. My expertise and proficiency of excel
Add your answer

Q1. No questions. Was confirmed my job
Add your answer

Loans

Never loss your Eye contact with the interviewer.

Q1. I need this job because this is a opportunity for me to achieve something.
Add your answer
Q2. About your family and where are u from?
Ans. There are five members in my family mom, dad, elder brother, younger sister n myself from indore, madhya pradesh.
Answered Anonymously
Add your answer