Magistral Research Analyst Interview Questions and Answers

Asking Questions related to their profile and work

Q1. Guess the number of Zomato users in bengaluru
Ans. 
It is difficult to accurately guess the number of Zomato users in Bengaluru without access to specific data.
• The number of Zomato users in Bengaluru can vary greatly depending on factors such as population size, internet penetration, and popularity of the app.

• One could make an educated guess by considering the total population of Bengaluru, the percentage of people who use food delivery apps, and Zomato's market share i...read more
Answered by AI
Add your answer

Q1. What are the accounting principles?
Ans. 
Accounting principles are the foundational guidelines that govern financial reporting and accounting practices.
• 1. Accrual Principle: Revenues and expenses are recorded when they are earned or incurred, not when cash is exchanged. Example: A company recognizes revenue when a service is provided, not when payment is received.

• 2. Consistency Principle: Companies should use the same accounting methods from period to period....read more
Answered by AI
Add your answer
Q2. What is the purpose of using a pivot table in Excel, and how do you utilize it?
Ans. 
Pivot tables in Excel summarize and analyze data efficiently, allowing for dynamic data exploration and reporting.
• Summarize large datasets: For example, you can summarize sales data by region and product category.

• Dynamic data analysis: Easily rearrange data by dragging and dropping fields to view different perspectives.

• Calculate aggregates: Use functions like SUM, AVERAGE, or COUNT to analyze data, such as total sales ...read more
Answered by AI
Add your answer
Q3. If we purchase a share for 100 rupees, what selling price do we need to achieve a profit of 20%?
Ans. 
To achieve a 20% profit on a share bought for 100 rupees, the selling price must be 120 rupees.
• Profit is calculated as: Profit = Selling Price - Cost Price.

• To find the selling price for a desired profit percentage, use the formula: Selling Price = Cost Price + (Cost Price * Profit Percentage).

• In this case: Selling Price = 100 + (100 * 0.20) = 100 + 20 = 120 rupees.

• Thus, selling the share for 120 rupees will yield a 20%...read more
Answered by AI
Add your answer

About basic understanding of accounting and excel

Q1. Excel understanding
Add your answer
Q2. Accounting process and golden principles of accounting
Ans. 
The accounting process involves recording, summarizing, analyzing, and reporting financial transactions. Golden principles include consistency, relevance, reliability, and comparability.
• Accounting process involves recording financial transactions, summarizing them into financial statements, analyzing the data, and reporting the results.

• Golden principles of accounting include consistency (using the same accounting metho...read more
Answered by AI
Add your answer

Q1. HR session then main panel of partners take interview.
Add your answer

Q1. Introduction , Qualifications and Experiences
Add your answer

Q1. Excel Formulas - VLOOKUP, HLOOKUP, Difference Between Sum / Sumif / Sumifs GST Implementation Year, Types of GST, Golden Rules of Accounting, Journal Entry of Sale and Purchase with GST and Bad debt journa...read more
Add your answer

How to use vloolup in 2 sheet