Groupm Media MIS Executive 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. Tell me About yourself
Ans. 
I am a dedicated MIS executive with 5 years of experience in data analysis, reporting, and system management.
• 5 years of experience in MIS role

• Proficient in data analysis and reporting

• Skilled in system management and troubleshooting

• Strong attention to detail and problem-solving abilities
Answered by AI
Add your answer
Q2. Basic excel shortcut
Add your answer

Pivot table
Chart
Sum
Sumit
If
If else
Vlookup
Hookup
Max min

Q1. Tell me about yourself
Ans. 
Experienced sales executive with a proven track record of exceeding targets and building strong client relationships.
• Over 5 years of sales experience in the technology industry

• Consistently met or exceeded sales targets by 20% each quarter

• Built and maintained relationships with key clients such as ABC Company and XYZ Corporation
Answered by AI
View 1 more answer
Q2. What did you do till you woke up
Ans. 
I prepared for the day ahead by reviewing my schedule, checking emails, and having breakfast.
• Reviewed schedule for the day

• Checked emails for any urgent messages

• Had breakfast to fuel up for the day
Answered by AI
Add your answer

Q1. Introduction, qualifications
Add your answer
Q2. Experience, qualifications
Add your answer

Q1. Basic digital media knowledge
Add your answer