Indira Gandhi International Airport Data Entry Operator Interview Questions and Answers

Knowledge of excel and advance excel

Q1. General questions
Add your answer
Q2. What is your current salary
Add your answer
Q3. What is your expected ctc
Ans. 
My expected CTC is based on my experience, skills, and the market rate for data analysts.
• My expected CTC is in line with industry standards for data analysts.

• I have taken into consideration my years of experience and expertise in data analysis.

• I am open to negotiation based on the overall compensation package offered by the company.
Answered by AI
Add your answer

Q1. First was Hr round, where he asked about myself, my experience, salary expectations, current salary.
Add your answer

Q1. Then the second round was with Arun Sir, who has asked advanced excel formulas, advanced google sheets formulas, SQL basics. And later told that will let you know, but haven't updated yet.
Add your answer
Q2. Dcount function ABS function Excel remove minus sign from integer using a formula.
Ans. 
Dcount function counts the number of unique values in a dataset. ABS function returns the absolute value of a number. To remove minus sign from an integer in Excel, use a formula like =ABS(A1).
• Dcount function counts unique values in a dataset

• ABS function returns absolute value of a number

• To remove minus sign from an integer in Excel, use formula like =ABS(A1)
Answered by AI
Add your answer
Q3. Filters Transfer data from 1 sheet to other Join , inner, outer, self, left right Along with the syntax Colene function in SQL Show top value show values between a date range Sumifs countifs
Ans. 
Answering questions related to data filtering, transferring, joining, and SQL functions for a Data Analyst role.
• To transfer data from one sheet to another, you can use functions like VLOOKUP or INDEX/MATCH in Excel.

• Different types of joins in SQL include INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, and SELF JOIN.

• Syntax for INNER JOIN: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;

• Synta...read more
Answered by AI
Add your answer

Q1. Be well-versed with C, SDLC and protocol standards
Add your answer

Q1. Storage classes, Volatile, Programs on arrays
Add your answer
Q2. Describe my project
Add your answer
Q3. SDLC in general
Ans. 
SDLC stands for Software Development Life Cycle, which is a process used by software development teams to design, develop, and test high-quality software.
• SDLC consists of several phases including planning, analysis, design, implementation, testing, and maintenance.

• Each phase has its own set of activities and deliverables to ensure the software meets the requirements and quality standards.

• Examples of SDLC models include...read more
Answered by AI
Add your answer
Q4. CAN protocol functionality
Ans. 
CAN protocol is a communication standard used in automotive and industrial applications.
• CAN protocol stands for Controller Area Network

• It is a message-based protocol used for communication between electronic control units (ECUs)

• CAN protocol allows for high-speed communication and real-time data transmission

• It is commonly used in automotive applications for functions such as engine control, transmission control, and bod...read more
Answered by AI
Add your answer

Basics aptitude questions related to various topics

Basic coding and sql and cloud concepts interview