AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Collegedunia
Compare
Filter interviews by
Collegedunia Operations Analyst Interview Questions, Process, and Tips
Top Collegedunia Operations Analyst Interview Questions and Answers
- Q1. Syntax for copying from one to another table in SQL
- Q2. Difference between Vlookup and Index match
- Q3. Shortcut key for pivot filter
Collegedunia Operations Analyst Interview Experiences
2 interviews found
ANKIT KUMAR Jha
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
(1 Question)
- Q1. Salary discussion
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.
Interview Questionnaire
6 Questions
- Q1. 1- Tell me about of your self
- Q2. What do you know about collegedunia
- Q3. Shortcut key for pivot filter
- Ans.
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
- Q4. Syntax for copying from one to another table in SQL
- Ans.
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
- Q5. Difference between Vlookup and Index match
- Ans.
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...
- Q6. Shortcut key for pivot table
- Ans.
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.
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
PARVEEN
(2 Questions)
- Q1. What's cycle count. How to manage inventory at a store.
- Q2. Liquidation
(1 Question)
- Q1. Manpower and UPL handling
(2 Questions)
- Q1. Ask about supply chain and operations
- Q2. Coding , big query and sql
Demand planning and capacity pla
(2 Questions)
- Q1. Facility and team size handled ?
- Ans.
Managed a facility with 200 employees and oversaw operations for a 500,000 square foot warehouse.
Managed a team of 200 employees
Oversaw operations for a 500,000 square foot warehouse
Handled facility operations efficiently
- Q2. Process improvement ideas implementation
(1 Question)
- Q1. Behavioural situation based quaetions
Interview Preparation Tips
I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.
(3 Questions)
- Q1. Introduce Yourself?
- Q2. Walk me through your resume?
- Q3. Tell us about your daily routine at work?
- Ans.
My daily routine at work involves overseeing team operations, coordinating tasks, resolving issues, and ensuring smooth workflow.
Start the day by reviewing the previous day's performance and setting goals for the current day
Hold a team meeting to discuss priorities, assign tasks, and address any challenges
Monitor team progress throughout the day, providing guidance and support as needed
Handle any escalated issues or co...
Selected
I applied via Job Fair and was interviewed in Aug 2024. There were 2 interview rounds.
Assignment related to local language to know our local language skills
(2 Questions)
- Q1. How much you know about yout local language
- Ans.
I am fluent in my local language and can communicate effectively in both spoken and written forms.
I am a native speaker of my local language
I have received formal education in my local language
I regularly use my local language in daily conversations and interactions
- Q2. How much you Can accomodate for your language
Senior Operations Manager Interview Questions & Answers
Stanza Living
Anonymous
posted on 17 Dec 2024
I applied via Company Website and was interviewed in Nov 2024. There was 1 interview round.
General aptitude and work experience.
Senior Operations Manager Interview Questions & Answers
Digit Insurance
Anonymous
posted on 19 Dec 2024
Selected
I applied via Approached by Company and was interviewed in Jun 2024. There were 2 interview rounds.
(1 Question)
- Q1. Related to Group Operations process
(1 Question)
- Q1. Salary discussion
Intime truck placement
(5 Questions)
- Q1. Customer payment details
- Q2. Fleet owners data
- Q3. Local Supply partners
- Q4. Local drivers and brokers
- Q5. PS audition truck accident issues
Collegedunia Interview FAQs
Tell us how to improve this page.
Collegedunia Interviews By Designations
- Collegedunia Business Development Manager Interview Questions
- Collegedunia Content Writer Interview Questions
- Collegedunia Data Researcher Interview Questions
- Collegedunia Education Counsellor Interview Questions
- Collegedunia Freelance Content Writer Interview Questions
- Collegedunia Management Trainee Interview Questions
- Collegedunia Operations Executive Interview Questions
- Collegedunia Academic Counsellor Interview Questions
- Show more
Interview Questions for Popular Designations
- Operations Executive Interview Questions
- Operations Manager Interview Questions
- Assistant Manager Operations Interview Questions
- Team Lead Operations Interview Questions
- Operations Associate Interview Questions
- Senior Executive Operations Interview Questions
- Operations Engineer Interview Questions
- Senior Operations Manager Interview Questions
- Show more
Collegedunia Operations Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Collegedunia Operations Analyst Reviews and Ratings
based on 12 reviews
Rating in categories
|
Business Development Manager
217
salaries
|  ₹4 L/yr - ₹12.2 L/yr |
|
Content Writer
179
salaries
| ₹1 L/yr - ₹8 L/yr |
|
Operations Analyst
112
salaries
| ₹2 L/yr - ₹7 L/yr |
|
Business Analyst
90
salaries
| ₹3.3 L/yr - ₹11.5 L/yr |
|
Data Analyst
87
salaries
| ₹2 L/yr - ₹9 L/yr |
Shiksha
Careers360
MeritNation
Toppr
- Home >
- Interviews >
- Collegedunia Interview Questions >
- Collegedunia Operations Analyst Interview Questions
