HDB Financial Services MIS Officer Interview Questions, Process, and Tips

Q1. Excel and Sql basic and advanced problems
Add your answer
Q2. How to use Vlookup ?
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Enter the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) in a cell

• lookup_value is the value to search for in the first column of the table_array

• table_array is the range of cells that contains the data

• col_index_num is the column number in the table_array from which to retr...read more
Answered by AI
Add your answer
Q3. How to use Splitting?
Ans. 
Splitting is a technique used to divide a string into multiple parts based on a specified delimiter.
• Use the split() method in programming languages like Python, JavaScript, or Java to split a string into an array of substrings.

• Specify the delimiter (e.g. space, comma, hyphen) as an argument to the split() method.

• Access the individual parts of the split string using array indexing.

• Combine splitting with other string man...read more
Answered by AI
Add your answer
Q4. How to use pivot ?
Ans. 
Pivot is a function used in data analysis to summarize and reorganize data.
• Pivot can be used to reorganize rows into columns or columns into rows based on a specific variable.

• It is commonly used in Excel or other spreadsheet software to create summary tables or reports.

• Pivot tables can help analyze large datasets and identify trends or patterns.

• Example: In Excel, you can use the PivotTable feature to summarize sales da
Answered by AI
Add your answer
Q5. How to use concatenation?
Ans. 
Concatenation is the process of combining two or more strings together.
• Use the + operator to concatenate strings in most programming languages.

• In SQL, use the CONCAT function to concatenate strings.

• Concatenation can also be done using string interpolation in some languages.
Answered by AI
Add your answer

Q1. Introduction about ur self
Ans. 
I am a dedicated and detail-oriented MIS Officer with a strong background in data analysis and information management.
• Experienced in analyzing and interpreting complex data sets

• Proficient in database management and reporting tools

• Skilled in developing and implementing data quality processes

• Strong communication and problem-solving skills

• Certified in relevant software applications such as SQL and Excel
Answered by AI
Add your answer

Q1. Excel test with advanced skills
Add your answer

Q1. Introduction about self, previous company and etc.
Add your answer

Excel test was there and if you know Sql than that's great.

Q1. Salary negotiation round
Add your answer

Q1. Advance Excel questions
Add your answer

Q1. About previous company work profile
Add your answer