Upload Button Icon Add office photos

Filter interviews by

CPM India Sales & Marketing MIS Executive Interview Questions and Answers

Updated 15 Feb 2025

CPM India Sales & Marketing MIS Executive Interview Experiences

2 interviews found

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 26 Jul 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Written 

(2 Questions)

  • 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
  • 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
Round 2 - HR 

(2 Questions)

  • 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
  • Q2. Questions related to Hobbies
Round 3 - Technical 

(2 Questions)

  • Q1. Countif, countifs, sumif, sumifs
  • Q2. Question related to vlookup

Skills evaluated in this interview

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 15 Feb 2025

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Feb 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Power query, pivot, chart DAX
  • Q2. Excel advanced

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare yourself & be confident.

MIS Executive Interview Questions Asked at Other Companies

Q1. HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU W ... read more
Q2. Excel function explain Pivot table. Vlookup.hole look-up.xlook-up ... read more
asked in HCLTech
Q3. What is the advantages of Data validation and why we use it?
Q4. WHAT YOU KNOW ABOUT ADVANCED EXCEL .AND EXPLAIN ABOUT THE CONDITI ... read more
Q5. Which formula do you know in excel Get this value usinhlg vlookup ... read more

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Basic intro Last work experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep updated with your profiles.
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Basic introduction
  • Q2. They asked about your background

Interview Preparation Tips

Interview preparation tips for other job seekers - I don't know

I applied via Naukri.com and was interviewed in Apr 2022. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About the Excel,ms knowledge.

Interview Preparation Tips

Interview preparation tips for other job seekers - It was basic of Excel and macro knowledge they have asked.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Advanced Excel questions
  • Q2. Sql questions
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Assignment 
Round 3 - One-on-one 
Round 4 - Technical 

Interview Preparation Tips

Interview preparation tips for other job seekers - Thank you

Interview Questionnaire 

1 Question

  • Q1. Formulas,QS

I applied via LinkedIn and was interviewed before Dec 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is sem in digital marketing?
  • Ans. 

    SEM stands for Search Engine Marketing, which involves promoting websites by increasing their visibility in search engine results pages.

    • SEM involves paid advertising on search engines like Google and Bing

    • It includes strategies like keyword research, ad copywriting, and bid management

    • SEM can be used to drive traffic, increase brand awareness, and generate leads or sales

    • Examples of SEM platforms include Google Ads, Bing

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prep well. do well and they will go in detail for each thing on the cv

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Little discussion on my project
  • Q2. Given a chessboard and the initial position of horse. If “n” is the number of steps the horse can make then what is probability that it goes out of board ?
  • Ans. 

    Probability of a horse going out of a chessboard in 'n' steps.

    • The total number of possible moves for a horse is 8.

    • The probability of going out of the board depends on the position of the horse.

    • For example, if the horse is at a corner, the probability of going out of the board is higher.

    • The probability can be calculated using combinatorics and geometry.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: They did not expect any code in this round. An algo or pseudo code is fine.



1) You are given 2 vessels with capacity M liters and N liters capacity and infinite supply of water. You need to find the minimum number of steps required to get P liters. Any of the below action is considered a step



     a) Filling vessel with water



     b) Emptying vessel



     c) Pouring water from one vessel to another vessel.



2) Given n sets each containing m integers. You need to create MinDiff set by picking exactly 1 element from each set. The difference between the maximum and minimum elements in the MinDiff set should be minimum.



eg: for the sets {30, 20, 10, 40},{ 22, 33, 44, 99},{ 16, 17, 18, 19} min diff set is {19, 20, 22}. Max and min elements in MinDiff set are 22 and 19 and their difference is 3.

Round: Technical Interview
Experience: 1) you will be given the binary representation of the numbers in the form of 2D array.eg: r1- 00001

r2- 00100

r3- 01010

r4- 00110

r5- 00111 This means the elements are 1, 4, 10 , 6 and 7.

A number “n” is given. Let us say that n can be formed by doing bitwise OR operation on rows of given matrix. What is the minimum number of rows that needs to be deleted from the matrix so that “n” can never be formed by doing the OR of the rows.

If n is 14(01110) then it can be formed by doing r2|r3 or r3|r4. You can prevent n formation either by deleting {r2,r4} or {r3}. But {r3} has least number of elements so it is the required set.2) Find the average of mid 50% of elements in the running stream of integersI have not cleared round-II so no further questions.

College Name: IIT GANDHINAGAR

CPM India Sales & Marketing Interview FAQs

How many rounds are there in CPM India Sales & Marketing MIS Executive interview?
CPM India Sales & Marketing interview process usually has 2 rounds. The most common rounds in the CPM India Sales & Marketing interview process are Technical and HR.
How to prepare for CPM India Sales & Marketing MIS Executive interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at CPM India Sales & Marketing. The most common topics and skills that interviewers at CPM India Sales & Marketing expect are Advanced Excel, MIS, Pivot Table, MIS Reporting and VLOOKUP.
What are the top questions asked in CPM India Sales & Marketing MIS Executive interview?

Some of the top questions asked at the CPM India Sales & Marketing MIS Executive interview -

  1. Which function is used to calculate weighted prod...read more
  2. What can we use to summarize the d...read more
  3. Countif, countifs, sumif, sum...read more

Tell us how to improve this page.

CPM India Sales & Marketing MIS Executive Interview Process

based on 2 interviews

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

R.R. Donnelley Interview Questions
3.9
 • 104 Interviews
Publicis Interview Questions
3.7
 • 52 Interviews
Denave Interview Questions
3.6
 • 40 Interviews
Smollan Group Interview Questions
4.1
 • 36 Interviews
Groupm Media Interview Questions
3.9
 • 35 Interviews
InMobi Interview Questions
3.4
 • 35 Interviews
MiQ Digital Interview Questions
3.3
 • 32 Interviews
Adglobal360 Interview Questions
3.2
 • 24 Interviews
View all
CPM India Sales & Marketing MIS Executive Salary
based on 89 salaries
₹2.3 L/yr - ₹3.8 L/yr
At par with the average MIS Executive Salary in India
View more details

CPM India Sales & Marketing MIS Executive Reviews and Ratings

based on 15 reviews

3.8/5

Rating in categories

3.8

Skill development

3.3

Work-life balance

2.8

Salary

3.1

Job security

2.9

Company culture

2.5

Promotions

3.3

Work satisfaction

Explore 15 Reviews and Ratings
MIS Executive
89 salaries
unlock blur

₹2.2 L/yr - ₹3.8 L/yr

Merchandiser
44 salaries
unlock blur

₹1.1 L/yr - ₹3 L/yr

Area Manager
31 salaries
unlock blur

₹4 L/yr - ₹7 L/yr

Supervisor
25 salaries
unlock blur

₹2.3 L/yr - ₹4.2 L/yr

Senior MIS Executive
24 salaries
unlock blur

₹3 L/yr - ₹5.2 L/yr

Explore more salaries
Compare CPM India Sales & Marketing with

R.R. Donnelley

3.9
Compare

Publicis

3.7
Compare

Groupm Media

3.9
Compare

Denave

3.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview