AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Guardian Pharmacy MIS Executive Interview Questions and Answers
Guardian Pharmacy MIS Executive Interview Experiences
1 interview found
Vicky Kumar Gupta
I applied via Naukri.com and was interviewed in Mar 2022. There were 3 interview rounds.
(1 Question)
- Q1. Previous company profile and skill sets.
(1 Question)
- Q1. Ms excel, Microsoft office, Sumifs, Countifs, Pivot Table, Avg
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Achit saxena
(2 Questions)
- Q1. Last experience
- Q2. Salary discussion
(1 Question)
- Q1. Acpected salary
Interview Preparation Tips
I applied via Referral and was interviewed before Aug 2020. There were 4 interview rounds.
Interview Questionnaire
8 Questions
- Q1. WHAT YOU KNOW ABOUT ADVANCED EXCEL .AND EXPLAIN ABOUT THE CONDITIONAL FORMATTING FUNCTIONS.
- Ans.
Conditional formatting in Advanced Excel allows users to apply formatting based on specified conditions.
Conditional formatting is a feature in Excel that allows users to format cells based on certain conditions.
It helps in highlighting data that meets specific criteria or rules.
Users can choose from various formatting options like font color, cell color, data bars, icon sets, etc.
Conditions can be based on values, form...
- Q2. HOW MUCH EXPERIENCE ON EXCEL BASED WORK.
- Q3. DO YOU KNOW ABOUT THE V-LOOKUP FORMULA
- Ans.
Yes, VLOOKUP is a formula used in Excel to search for a specific value in a column and return a corresponding value from another column.
VLOOKUP stands for vertical lookup.
It is commonly used to find data in large spreadsheets.
The formula has four arguments: lookup value, table array, column index number, and range lookup.
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 an...
- Q4. WHAT IS TEXT FORMULAS .HOW DOES IT WORKS ON EXCEL.
- Ans.
Text formulas in Excel are used to manipulate and combine text strings. They work by using specific functions and operators.
Text formulas are used to perform operations on text strings in Excel.
They can be used to concatenate, extract, replace, and manipulate text.
Text formulas are created using functions and operators.
Examples of text formulas include CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE, and LEN.
Text formulas ca...
- Q5. EXPLAIN ABOUT DIFFERNCE BETWEEN MATCH AND INDEX FUNCTIONS.
- Ans.
MATCH and INDEX are Excel functions used for different purposes.
MATCH function is used to find the position of a value in a range or array.
INDEX function is used to retrieve the value at a specific row and column intersection in a range or array.
MATCH function returns the relative position of a value, while INDEX function returns the actual value.
MATCH function can be used for approximate or exact matches, while INDEX ...
- Q6. HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU WAS USING ON YOUR PREVIOUS ORGANISATION.
- Ans.
To create a pivot table in Excel, go to the 'Insert' tab, click on 'PivotTable', select the data range, choose the location, and set the fields.
Go to the 'Insert' tab in Excel
Click on 'PivotTable'
Select the data range you want to use for the pivot table
Choose the location where you want the pivot table to be placed
Set the fields for the pivot table by dragging and dropping them into the 'Rows', 'Columns', and 'Values' ...
- Q7. HOW MANY TYPES OF TO YOU EXTRACTING DATA .AND ALSO HOW TO EXPORT THE DATA.
- Ans.
There are multiple types of data extraction methods and various ways to export the data.
Types of data extraction methods include web scraping, database querying, API integration, and ETL processes.
Data can be exported in various formats such as CSV, Excel, JSON, XML, or directly into databases.
Exporting data can be done through software tools, programming languages, or using built-in export functionalities of applicati...
- Q8. HOW TO GET RAW DATA OR WORK ON YOUR ORGANISATION.
- Ans.
To get raw data or work on your organization, you can utilize various methods such as accessing databases, using APIs, conducting surveys, or analyzing existing reports.
Access databases to extract raw data
Utilize APIs to retrieve data from external sources
Conduct surveys to collect relevant information
Analyze existing reports or documents within the organization
Use data mining techniques to extract valuable insights
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Walk-in and was interviewed in Jul 2023. There was 1 interview round.
(5 Questions)
- Q1. Type of Granulation
- Ans.
Granulation can be either wet or dry, with each method having its own advantages and disadvantages.
Granulation can be categorized as wet granulation or dry granulation.
Wet granulation involves the addition of a liquid binder to the powder mixture, followed by drying and sizing.
Dry granulation involves compacting the powder mixture without the use of liquid binders.
Examples of wet granulation include high-shear granulat...
- Q2. What is automation
- Ans.
Automation is the use of technology to perform tasks with minimal human intervention.
Automation involves the use of machines, software, and other technologies to carry out tasks that would otherwise be done by humans.
Examples of automation include robotic process automation (RPA), self-driving cars, and smart home devices.
Automation can increase efficiency, reduce errors, and save time and money for businesses.
- Q3. Between the FBD FBP and FBE
- Ans.
FBD FBP and FBE are different types of insurance policies.
FBD (Full Business Day) insurance covers loss of income due to business interruption.
FBP (Full Business Protection) insurance covers both property damage and business interruption.
FBE (Full Business Enhancement) insurance offers additional coverage options to enhance a standard policy.
- Q4. Punch inspection and moc of dia and punch
- Q5. Gun validation gun nozzel size
Skills evaluated in this interview
(2 Questions)
- Q1. Last experience
- Q2. Salary discussion
(1 Question)
- Q1. Acpected salary
Interview Preparation Tips
(1 Question)
- Q1. Tell us in brief about yourself
(1 Question)
- Q1. Tell us something about yourself
Interview Preparation Tips
I applied via Referral and was interviewed before Aug 2020. There were 4 interview rounds.
Interview Questionnaire
8 Questions
- Q1. WHAT YOU KNOW ABOUT ADVANCED EXCEL .AND EXPLAIN ABOUT THE CONDITIONAL FORMATTING FUNCTIONS.
- Ans.
Conditional formatting in Advanced Excel allows users to apply formatting based on specified conditions.
Conditional formatting is a feature in Excel that allows users to format cells based on certain conditions.
It helps in highlighting data that meets specific criteria or rules.
Users can choose from various formatting options like font color, cell color, data bars, icon sets, etc.
Conditions can be based on values, form...
- Q2. HOW MUCH EXPERIENCE ON EXCEL BASED WORK.
- Q3. DO YOU KNOW ABOUT THE V-LOOKUP FORMULA
- Ans.
Yes, VLOOKUP is a formula used in Excel to search for a specific value in a column and return a corresponding value from another column.
VLOOKUP stands for vertical lookup.
It is commonly used to find data in large spreadsheets.
The formula has four arguments: lookup value, table array, column index number, and range lookup.
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 an...
- Q4. WHAT IS TEXT FORMULAS .HOW DOES IT WORKS ON EXCEL.
- Ans.
Text formulas in Excel are used to manipulate and combine text strings. They work by using specific functions and operators.
Text formulas are used to perform operations on text strings in Excel.
They can be used to concatenate, extract, replace, and manipulate text.
Text formulas are created using functions and operators.
Examples of text formulas include CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE, and LEN.
Text formulas ca...
- Q5. EXPLAIN ABOUT DIFFERNCE BETWEEN MATCH AND INDEX FUNCTIONS.
- Ans.
MATCH and INDEX are Excel functions used for different purposes.
MATCH function is used to find the position of a value in a range or array.
INDEX function is used to retrieve the value at a specific row and column intersection in a range or array.
MATCH function returns the relative position of a value, while INDEX function returns the actual value.
MATCH function can be used for approximate or exact matches, while INDEX ...
- Q6. HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU WAS USING ON YOUR PREVIOUS ORGANISATION.
- Ans.
To create a pivot table in Excel, go to the 'Insert' tab, click on 'PivotTable', select the data range, choose the location, and set the fields.
Go to the 'Insert' tab in Excel
Click on 'PivotTable'
Select the data range you want to use for the pivot table
Choose the location where you want the pivot table to be placed
Set the fields for the pivot table by dragging and dropping them into the 'Rows', 'Columns', and 'Values' ...
- Q7. HOW MANY TYPES OF TO YOU EXTRACTING DATA .AND ALSO HOW TO EXPORT THE DATA.
- Ans.
There are multiple types of data extraction methods and various ways to export the data.
Types of data extraction methods include web scraping, database querying, API integration, and ETL processes.
Data can be exported in various formats such as CSV, Excel, JSON, XML, or directly into databases.
Exporting data can be done through software tools, programming languages, or using built-in export functionalities of applicati...
- Q8. HOW TO GET RAW DATA OR WORK ON YOUR ORGANISATION.
- Ans.
To get raw data or work on your organization, you can utilize various methods such as accessing databases, using APIs, conducting surveys, or analyzing existing reports.
Access databases to extract raw data
Utilize APIs to retrieve data from external sources
Conduct surveys to collect relevant information
Analyze existing reports or documents within the organization
Use data mining techniques to extract valuable insights
Interview Preparation Tips
Skills evaluated in this interview
Guardian Pharmacy Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior MIS Executive Interview Questions
- MIS Executive and Analyst Interview Questions
- MIS Executive and Coordinator Interview Questions
- Executive Interview Questions
- Sales Executive Interview Questions
- Senior Executive Interview Questions
- MIS and Back Office Executive Interview Questions
- Executive Accountant Interview Questions
- Show more
Interview Questions from Similar Companies
|
Pharmacist
17
salaries
|  ₹2 L/yr - ₹3.8 L/yr |
|
Retail Store Manager
4
salaries
| ₹2.4 L/yr - ₹3.8 L/yr |
|
Store Manager
4
salaries
| ₹2 L/yr - ₹3.5 L/yr |
|
Pharmacy Assistant
4
salaries
| ₹2.4 L/yr - ₹3 L/yr |
|
Hospital Pharmacist
4
salaries
| ₹3.3 L/yr - ₹3.5 L/yr |
Apollo Pharmacy
MedPlus
Netmeds.com
PharmEasy
- Home >
- Interviews >
- Guardian Pharmacy Interview Questions >
- Guardian Pharmacy MIS Executive Interview Questions
