PR Newswire Interview Questions and Answers

The aptitude test consisted of a combination of three types of subjects: Quantitative, English, and Logical Reasoning. The difficulty level was challenging, and it would be beneficial to review the basics of the CAT exam.

Q1. What is the SUBSTITUTE function in Excel, and how can it be used?
Ans. 
The SUBSTITUTE function in Excel replaces a specific occurrence of a text string with another text string.
• Syntax: SUBSTITUTE(text, old_text, new_text, instance_num)

• text: The original text string where replacement will occur

• old_text: The text string to be replaced

• new_text: The text string to replace old_text with

• instance_num: Optional parameter to specify which occurrence of old_text to replace

• Example: =SUBSTITUTE("appl...read more
Answered by AI
Add your answer
Q2. What is a pivot table in Excel, and how can it be accessed and utilized?
Ans. 
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
• Accessed by selecting the data range you want to analyze, then going to the 'Insert' tab and clicking on 'PivotTable'.

• Utilized by dragging and dropping fields into the 'Rows', 'Columns', 'Values', and 'Filters' areas to organize and summarize data.

• Can be used to quickly analyze large dataset...read more
Answered by AI
Add your answer
Q3. What are the differences between Tableau and Power BI, and which one is considered superior?
Ans. 
Tableau and Power BI are both powerful data visualization tools, with Tableau being more user-friendly and Power BI offering better integration with Microsoft products.
• Tableau is known for its user-friendly interface and ease of use for creating visually appealing dashboards.

• Power BI offers better integration with Microsoft products such as Excel, SharePoint, and SQL Server.

• Tableau is considered superior for its ease o...read more
Answered by AI
Add your answer
Q4. What is the process to sort the top 10 rows in Excel?
Ans. 
To sort the top 10 rows in Excel, select the range of data, go to the Data tab, click on Sort, choose the column to sort by, select Top 10 from the options, and specify whether to sort in ascending or descending order.
• Select the range of data containing the top 10 rows you want to sort.

• Go to the Data tab in Excel.

• Click on the Sort button.

• Choose the column you want to sort by.

• Select 'Top 10' from the 'Sort On' dropdown ...read more
Answered by AI
Add your answer
Q5. What is adjusted R-squared in descriptive statistics, and what information can be derived from it?
Ans. 
Adjusted R-squared is a statistical measure that adjusts the R-squared value for the number of predictors in a regression model.
• Adjusted R-squared takes into account the number of predictors in a regression model, providing a more accurate measure of the model's goodness of fit.

• It penalizes the addition of unnecessary predictors, helping to prevent overfitting.

• A higher adjusted R-squared value indicates a better fit of...read more
Answered by AI
Add your answer
Q6. What is correlation, and what conclusions can be drawn from it?
Ans. 
Correlation is a statistical measure that describes the relationship between two variables.
• Correlation can range from -1 to 1, with 0 indicating no correlation, 1 indicating a perfect positive correlation, and -1 indicating a perfect negative correlation.

• A positive correlation means that as one variable increases, the other variable also tends to increase. For example, there is a positive correlation between studying h...read more
Answered by AI
Add your answer

Q1. What are the five stages of project?
Ans. 
The five stages of a project are initiation, planning, execution, monitoring and controlling, and closing.
• Initiation: Defining the project, its scope, objectives, and stakeholders.

• Planning: Creating a detailed project plan, including tasks, timelines, resources, and budget.

• Execution: Carrying out the project plan and completing the work.

• Monitoring and Controlling: Tracking project progress, managing changes, and ensuri...read more
Answered by AI
Add your answer
Q2. What is the difference between a project manager and a product manager?
Ans. 
Project managers focus on overseeing the execution of a specific project, while product managers are responsible for the overall strategy and development of a product.
• Project managers are focused on the successful completion of a project within scope, budget, and time constraints.

• Product managers are responsible for the strategic direction, development, and success of a product throughout its lifecycle.

• Project managers...read more
Answered by AI
Add your answer
Q3. What are two limitations of food delivery apps that you believe need improvement?
Ans. 
Limitations of food delivery apps that need improvement
• Inaccurate delivery times leading to customer dissatisfaction

• Limited restaurant options available on the app

• Difficulty in customizing orders or making special requests

• Issues with order accuracy and missing items

• Lack of transparency in pricing and additional fees
Answered by AI
Add your answer
Q4. Can you provide a real-life example of a project where you led a team to successful completion?
Ans. 
Led a team to successfully launch a new software application for a client
• Developed project timeline and milestones

• Assigned tasks to team members based on their strengths

• Held regular team meetings to track progress and address any issues

• Collaborated with client to ensure project met their expectations

• Conducted thorough testing and quality assurance before final launch
Answered by AI
Add your answer

Q1. What is your place of domicile?
Ans. 
I currently reside in a cozy apartment in downtown Seattle.
• My place of domicile is in Seattle, Washington.

• I live in a cozy apartment in downtown Seattle.

• I have been a resident of Seattle for the past five years.
Answered by AI
Add your answer
Q2. Can you describe your family background and the members who live in your household?
Ans. 
I come from a close-knit family with my parents and two siblings living in our household.
• Close-knit family

• Parents and two siblings

• Living together in the same household
Answered by AI
Add your answer
Q3. Is the family income derived from a business or from job holders?
Ans. 
Family income can be derived from both a business and job holders.
• Family income can come from a business owned by a family member.

• Family income can also come from salaries earned by family members from their jobs.

• In some cases, family income may be a combination of income from both business and job holders.

• Examples: A family may own a small business like a bakery and also have family members working in corporate jobs.

• A...read more
Answered by AI
Add your answer
Q4. What is your motivation for choosing to work in the insurance industry?
Ans. 
I am motivated to work in the insurance industry because of its stability, growth opportunities, and the chance to help individuals and businesses protect themselves financially.
• Stability: Insurance is a stable industry that is less affected by economic downturns.

• Growth opportunities: There are various career paths and opportunities for advancement within the insurance industry.

• Helping others: Working in insurance allo...read more
Answered by AI
Add your answer
Q5. Are you willing to relocate to Bengaluru?
Ans. 
Yes, I am willing to relocate to Bengaluru for the Project Manager position.
• I am open to relocating for the right opportunity

• I have experience working in different locations

• I am excited about the prospect of working in Bengaluru
Answered by AI
Add your answer

Q1. What is railways?
Add your answer
Q2. How many kinds of weldings are done in Railways?
Add your answer

Q1. How you are going through with the current company?
Add your answer
Q2. How many days of notice periode you have to serve in current company?
Add your answer

Q1. How many years you are working with your current industry?
Add your answer
Q2. How is your experience in your current industry and what you learned there?
Add your answer

Q1. Asking and negotiation about CTC!
Add your answer

Q1. Tell me about yourself and workex, One campaign you are proud of and what you did, The interview lasted for 30 mins.
Add your answer
Q2. Why are you leaving your current company and details on that.
Ans. 
Seeking new challenges and opportunities for growth.
• Desire for new challenges and opportunities for growth

• Looking for a company with better work-life balance

• Seeking a role with more responsibility and leadership opportunities
Answered by AI
Add your answer

Q1. Tell me about yourself, 2 digital campaigns that you did and what you learn from them, Logical question on bulb : 3 bulbs are in a room and it's switches are outside the room, and you can only enter the ro...read more
Add your answer
Q2. How many times does whatsapp application gets open in your household?
Ans. 
WhatsApp is opened multiple times daily in my household for communication and sharing updates.
• WhatsApp is opened multiple times daily for communication with family and friends

• Used for sharing updates, photos, and videos

• Helps in coordinating plans and staying connected with loved ones
Answered by AI
Add your answer

Q1. Write clean code for api call and DB update and ui update LLD
Ans. 
Design a clean code structure for API call, DB update, and UI update.
• Separate concerns by creating separate classes or modules for API call, DB update, and UI update.

• Use interfaces or abstract classes to define contracts for each component.

• Implement error handling and data validation at each step.

• Consider using asynchronous programming to prevent blocking the UI thread.

• Use dependency injection to manage dependencies be
Answered by AI
Add your answer
Q2. Questions on Kotlin
Add your answer

Q1. Machine coding related to multiple view type recycler view
Add your answer
Q2. Further discussion on callback lifecycles of adapter methods when & how many times they will be called
Add your answer
Q3. How to sync which item is shown to backend in recycler view using api call . How to optimise it
Ans. 
Use a unique identifier for each item in the recycler view and send it to the backend via API calls. Optimize by batching API calls and implementing pagination.
• Assign a unique identifier to each item in the recycler view, such as an ID or position

• Send the unique identifier of the currently shown item to the backend through API calls

• Optimize by batching API calls to reduce network overhead

• Implement pagination to load da
Answered by AI
Add your answer

Q1. Journey so far what you learned . Reasons for switching company , Incidents of conflicts with. manager
Ans. 
I have learned a lot in my journey so far, leading to my decision to switch companies. I have had conflicts with managers in the past.
• Learned new technologies and tools in current role

• Developed strong problem-solving and communication skills

• Decided to switch companies for career growth opportunities

• Had conflicts with a manager due to differing opinions on project direction
Answered by AI
Add your answer

Q1. They start with asking what you do
Add your answer
Q2. Do you know about collegedunia
Add your answer
Q3. Why you want to quit your current job
Add your answer
Q4. What's your current salary and how much you are expecting
Add your answer

Q1. Starts with Your introduction
Add your answer
Q2. Then basic terms like CPC, CTR, ROAS, ROI, CPS, CPV, Affiliate marketing and so on
Add your answer

A case study is a detailed examination of a specific individual, group, event, organization, or phenomenon, allowing researchers to analyze a situation deeply and understand its various elements by gathering information through methods like interviews, observations, and document analysis; the goal is to identify patterns, challenges, and potential solutions within the unique context of the case, often used in fields like social science, medicine, business, and education to explore complex situations and develop practical insights.

"case assignment" refers to the process of assigning a specific case, usually a real-world scenario or problem, to an individual or team to analyze, evaluate, and provide solutions within an academic or professional setting; key details include the case subject, relevant background information, key questions to address, expected deliverables, and deadlines, allowing the assignee to apply theoretical knowledge to practical situations and develop critical thinking

Q1. Do you know google sheet
Add your answer
Q2. Do you know advance excel
Add your answer
Q3. Will you agree while change department
Add your answer

Q1. Do you know costing
Add your answer
Q2. Will you be flexible
Add your answer

Q1. What is your current work experience, and can you provide a case study on how to improve monetization for Netflix?
Add your answer

Q1. Case Study - Favourite product
Add your answer