i
Collegedunia
Filter interviews by
I was interviewed in Mar 2023.
Q- conditional formatting
Q- alter query of sql
Q- html tags
Q-vlookup question
Q-which is good vlookup or indexmatch
Q- countif function
Q- create view in sql
Q- problem solving question
I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.
Alt + Down Arrow
Press Alt key and Down Arrow key simultaneously
Shortcut key is used to open the filter drop-down menu for pivot tables
Can be used to quickly filter data in pivot tables
Syntax for copying data from one table to another in SQL
Use INSERT INTO statement with SELECT subquery
Specify the source table and columns in SELECT subquery
Specify the destination table and columns in INSERT INTO statement
Vlookup searches for a value in the first column of a table and returns a corresponding value in the same row. Index match uses the index function to find a value in a table and match function to return a corresponding value in the same row.
Vlookup only works from left to right, while Index match can work in any direction.
Index match is more flexible and efficient for large datasets.
Index match can handle errors better...
The shortcut key for pivot table is Alt + D + P.
Press Alt key and then press D and P keys in sequence to create a pivot table.
This shortcut works in Microsoft Excel.
Pivot tables are used to summarize and analyze large amounts of data.
Top trending discussions
I applied via Walk-in and was interviewed before Sep 2021. There were 2 interview rounds.
I was interviewed in Jan 2025.
I am a seasoned Operations Executive with over 10 years of experience in optimizing processes and driving efficiency.
Managed cross-functional teams to streamline operations
Implemented cost-saving initiatives resulting in 20% reduction in expenses
Led successful implementation of new ERP system
Improved customer satisfaction by 15% through process improvements
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Statistics and have completed multiple data analysis projects during my studies.
I am proficient in using statistical software such as R and Python to analyze and interpret data.
I have experience in creating visualizations and reports to communicate findings to stakeholders.
I am a quic...
I am impressed by your company's innovative approach and strong reputation in the industry.
I am attracted to the company's commitment to innovation and cutting-edge technology.
I admire the company's strong reputation and track record of success.
I believe that the company's values align with my own professional goals and aspirations.
I applied via Referral and was interviewed before Aug 2022. There were 3 interview rounds.
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
Number system, and basic apptitude questions
based on 1 interview
Interview experience
based on 12 reviews
Rating in categories
Business Development Manager
215
salaries
| ₹0 L/yr - ₹0 L/yr |
Content Writer
179
salaries
| ₹0 L/yr - ₹0 L/yr |
Operations Analyst
112
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
90
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
87
salaries
| ₹0 L/yr - ₹0 L/yr |
Shiksha
Careers360
MeritNation
Toppr