AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Rosmerta Technologies Senior MIS Analyst Interview Questions and Answers
6 Interview questions
To prepare an MIS report in Excel, follow these steps:
Identify the data to be included in the report
Organize the data in a structured format
Use Excel functions and formulas to calculate metrics
Create charts and graphs to visualize the data
Format the report for readability and clarity
Include a summary or conclusion section
Save the report and share with relevant stakeholders
The constraint of a VLOOKUP function is that it can only look up values in the leftmost column of a table.
VLOOKUP can only search for values in the first column of a table
The lookup value must be in the leftmost column of the table
If you need to search for values in other columns, you need to use INDEX/MATCH instead
MIS stands for Management Information System. There are mainly four types of MIS: Strategic, Tactical, Operational, and Decision Support System.
Strategic MIS: Helps in long-term planning and decision-making.
Tactical MIS: Helps in short-term planning and decision-making.
Operational MIS: Helps in day-to-day operations and monitoring.
Decision Support System: Helps in complex decision-making by providing analytical to...
Protect sheet from editing by setting password and restricting access.
Set a password to protect the sheet
Restrict access to the sheet by only allowing authorized users to edit
Use Excel's Protect Sheet feature to prevent editing
Use VBA code to protect the sheet and prevent unauthorized access
There are several report formats available in MS Excel.
Excel offers various report formats such as tables, charts, pivot tables, and pivot charts.
Tables are used to organize data in rows and columns.
Charts are used to visually represent data in different formats such as bar, line, and pie charts.
Pivot tables are used to summarize and analyze large amounts of data.
Pivot charts are used to visually represent data fr...
MIS stands for Management Information System. It is a computer-based system that provides information to support decision-making.
MIS collects, processes, and stores data from various sources.
It generates reports and provides analysis to support decision-making.
MIS helps in planning, controlling, and organizing business operations.
Examples of MIS include ERP systems, CRM systems, and financial management systems.
Rosmerta Technologies Senior MIS Analyst Interview Experiences
1 interview found
Interview Questionnaire
6 Questions
- Q1. What is MIS, what is purpose of an MIS
- Ans.
MIS stands for Management Information System. It is a computer-based system that provides information to support decision-making.
MIS collects, processes, and stores data from various sources.
It generates reports and provides analysis to support decision-making.
MIS helps in planning, controlling, and organizing business operations.
Examples of MIS include ERP systems, CRM systems, and financial management systems.
- Q2. What are the different type of MIS
- Ans.
MIS stands for Management Information System. There are mainly four types of MIS: Strategic, Tactical, Operational, and Decision Support System.
Strategic MIS: Helps in long-term planning and decision-making.
Tactical MIS: Helps in short-term planning and decision-making.
Operational MIS: Helps in day-to-day operations and monitoring.
Decision Support System: Helps in complex decision-making by providing analytical tools a...
- Q3. How can you protect your sheet from anyone editing the data
- Ans.
Protect sheet from editing by setting password and restricting access.
Set a password to protect the sheet
Restrict access to the sheet by only allowing authorized users to edit
Use Excel's Protect Sheet feature to prevent editing
Use VBA code to protect the sheet and prevent unauthorized access
- Q4. What is the constraint of a VLOOKUP function
- Ans.
The constraint of a VLOOKUP function is that it can only look up values in the leftmost column of a table.
VLOOKUP can only search for values in the first column of a table
The lookup value must be in the leftmost column of the table
If you need to search for values in other columns, you need to use INDEX/MATCH instead
- Q5. How many report formats are available in MS Excel
- Ans.
There are several report formats available in MS Excel.
Excel offers various report formats such as tables, charts, pivot tables, and pivot charts.
Tables are used to organize data in rows and columns.
Charts are used to visually represent data in different formats such as bar, line, and pie charts.
Pivot tables are used to summarize and analyze large amounts of data.
Pivot charts are used to visually represent data from pi...
- Q6. How do prepare an MIS report in excel
- Ans.
To prepare an MIS report in Excel, follow these steps:
Identify the data to be included in the report
Organize the data in a structured format
Use Excel functions and formulas to calculate metrics
Create charts and graphs to visualize the data
Format the report for readability and clarity
Include a summary or conclusion section
Save the report and share with relevant stakeholders
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
Apptitude and technical mcqs
(1 Question)
- Q1. Sql queries and the projects that i have done
(1 Question)
- Q1. Normal hr round
I applied via Company Website and was interviewed in Sep 2023. There were 3 interview rounds.
Test was of 20 questions 20 minutes medium level aptitude questions
(1 Question)
- Q1. General HR questions
(1 Question)
- Q1. Nothing much technical in this round also.panel of 3 members interacted very friendly.
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Dec 2022. There were 4 interview rounds.
(1 Question)
- Q1. Based on my resume and my previous company and Statistics
(1 Question)
- Q1. Related to Statistics
(1 Question)
- Q1. Salary negotiation.
Business Analyst Interview Questions & Answers
Ola Electric Mobility
Anonymous
posted on 25 Oct 2023
Normal CAT level questions
(1 Question)
- Q1. Asked some guesstimates and some SQL
Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell about yourself
- Ans.
I am a data analyst with a strong background in statistics and data visualization.
Graduated with a degree in Statistics
Proficient in programming languages like Python and R
Experience in analyzing large datasets and creating data visualizations
Strong problem-solving skills
- Q2. What are the steps you do for Data cleaning
- Ans.
Data cleaning involves removing or correcting errors in a dataset to ensure accuracy and consistency.
Remove duplicate entries
Fill in missing values
Correct formatting errors
Identify and remove outliers
Standardize data types
Interview Preparation Tips
Business Analyst Interview Questions & Answers
Escorts Kubota Limited
Anonymous
posted on 12 Feb 2025
Selected
I appeared for an interview before Feb 2024.
(2 Questions)
- Q1. General question about your experience. Few samples they might collect later of your earlier work to provide some idea about your wrk and idea.
- Q2. Not much technical, if you know what u wrote on resume with some examples to share that will be best.
Interview Preparation Tips
General question about your ambition, ur wrk experience, and Weakness and strength.
Selected
I applied via Campus Placement and was interviewed before Apr 2022. There were 3 interview rounds.
(1 Question)
- Q1. Projects Business case study
(1 Question)
- Q1. Family details Pressure questions
Interview Preparation Tips
(2 Questions)
- Q1. Explain about yourself
- Ans.
I am a data analyst with a strong background in statistics and data visualization.
Graduated with a degree in Statistics
Proficient in programming languages like Python and R
Experience in analyzing large datasets and creating data visualizations
Strong problem-solving skills and attention to detail
- Q2. What is ur experience on Data analyst
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before Sep 2023. There was 1 interview round.
(2 Questions)
- Q1. Explain the experience in data
- Ans.
I have over 5 years of experience in data analysis, including working with large datasets, creating visualizations, and providing actionable insights.
Experience in cleaning and transforming data to ensure accuracy and consistency
Proficient in using statistical tools and techniques to analyze data
Ability to create data visualizations and dashboards to communicate findings
Experience in identifying trends and patterns in ...
- Q2. Explain the courses done in data analyst
- Ans.
Courses in data analyst cover topics such as statistics, data visualization, machine learning, and data mining.
Statistics: Understanding of statistical concepts and techniques for data analysis.
Data Visualization: Creating visual representations of data to aid in analysis and decision-making.
Machine Learning: Using algorithms and models to analyze and make predictions based on data.
Data Mining: Extracting patterns and ...
Interview Preparation Tips
Rosmerta Technologies Interview FAQs
Tell us how to improve this page.
Rosmerta Technologies Interviews By Designations
- Rosmerta Technologies Computer Operator Interview Questions
- Rosmerta Technologies Graduate Trainee Interview Questions
- Rosmerta Technologies Project Coordinator Interview Questions
- Rosmerta Technologies Project Manager Interview Questions
- Rosmerta Technologies Accountant Interview Questions
- Rosmerta Technologies Production Manager Interview Questions
- Rosmerta Technologies Software Developer Interview Questions
- Rosmerta Technologies Quality Assurance/Quality Control Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Analyst Interview Questions
- Data Analyst Interview Questions
- Senior Consultant Interview Questions
- Senior Analyst Interview Questions
- Programmer Analyst Interview Questions
- Senior Business Analyst Interview Questions
- Research Analyst Interview Questions
- Associate Analyst Interview Questions
- Show more
Interview Questions from Similar Companies
Rosmerta Technologies Senior MIS Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
MIS Executive
61
salaries
|  ₹2 L/yr - ₹4 L/yr |
|
Assistant Manager
41
salaries
| ₹3.7 L/yr - ₹8.5 L/yr |
|
Project Manager
29
salaries
| ₹3.6 L/yr - ₹13.5 L/yr |
|
Operations Manager
25
salaries
| ₹4.4 L/yr - ₹12 L/yr |
|
Executive Accountant
22
salaries
| ₹2.6 L/yr - ₹5.4 L/yr |
Escorts Kubota Limited
Sonalika Tractors
Ola Electric Mobility
Force Motors
- Home >
- Interviews >
- Rosmerta Technologies Interview Questions
