CPM India Sales & Marketing Interview Questions and Answers

Q1. Which function is used to calculate weighted product
Ans. 
The function used to calculate weighted product is the SUMPRODUCT function.
• The SUMPRODUCT function multiplies corresponding components in the given arrays and returns the sum of those products.

• It is commonly used in financial analysis, inventory management, and supply chain optimization.

• Example: =SUMPRODUCT(A1:A3, B1:B3) will calculate the weighted product of values in cells A1 to A3 and B1 to B3.
Answered by AI
Add your answer
Q2. What can we use to summarize the data
Ans. 
Data can be summarized using various methods such as charts, graphs, tables, and statistical measures.
• Charts: Visual representation of data like bar charts, pie charts, line graphs.

• Graphs: Representing data points and relationships between them.

• Tables: Organizing data in rows and columns for easy comparison.

• Statistical measures: Calculating averages, medians, standard deviations, etc.
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated MIS executive with a strong background in data analysis and reporting.
• Experienced in managing databases and generating reports for decision-making

• Proficient in data visualization tools such as Tableau and Power BI

• Skilled in identifying trends and patterns in data to improve business processes
Answered by AI
Add your answer
Q2. Questions related to Hobbies
Add your answer

Q1. Countif, countifs, sumif, sumifs
Add your answer
Q2. Question related to vlookup
Add your answer

इस कार्य को पहले कभी किया है या नहीं

कार्य के बारे में जानकारी दी गई

Q1. How will you achieve targets?
Ans. 
I will achieve targets by setting clear goals, creating a strategic plan, monitoring progress regularly, and making necessary adjustments.
• Setting specific, measurable, achievable, relevant, and time-bound (SMART) goals

• Developing a strategic plan outlining steps to reach targets

• Regularly monitoring progress and performance

• Making adjustments to strategies if needed to stay on track

• Leveraging market insights and trends to
Answered by AI
Add your answer

Q1. How would u sale a Water Battle
Ans. 
I would highlight the durability, convenience, and versatility of the water bottle.
• Emphasize the high-quality materials used in the water bottle for durability.

• Highlight the convenience of being able to carry water on-the-go.

• Mention the versatility of the water bottle for use in various activities such as hiking, biking, or working out.
Answered by AI
Add your answer
Q2. Asked me to Sale the Tv
Add your answer

Q1. Asked me To sale the Bronze water battle
Add your answer