Indus Towers MIS Executive Interview Questions and Answers

To separate date and time, use a combination of string manipulation and date/time functions.

• Extract the date and time from the original string using string manipulation functions like substring or split.

• Convert the date and time strings into date/time objects using a date/time function like new Date() or moment().

• Format the date and time objects into the desired output format using a date/time function like toLoca...read more

HLOOKUP is used to search for a value in the top row of a table and return a corresponding value in the same column from a specified row.

• Identify the top row of the table where you want to search for a value

• Specify the row number from where you want to return the corresponding value

• Use the HLOOKUP function with the lookup value, table array, row number, and range lookup parameters

• Example: =HLOOKUP(A2, B1:E4, 3, FA...read more

I am a dedicated MIS Executive with strong communication skills and a passion for continuous learning and improvement.

• Hardworking: I consistently put in extra effort to meet deadlines and exceed expectations, such as working late to complete a critical project.

• Good communicator: I effectively convey complex information to team members and stakeholders, ensuring everyone is on the same page.

• Eager learner: I activel...read more

Syntax of sum product SQL queries

• SUM query syntax: SELECT SUM(column_name) FROM table_name WHERE condition;

• PRODUCT query syntax: SELECT column1 * column2 AS product_column FROM table_name WHERE condition;

Excel functions including Pivot table, Vlookup, Xlookup, Duplicate remove, ERP, and SAP.

• Pivot table: summarizes and analyzes data in a table

• Vlookup: searches for a value in a table and returns a corresponding value

• Xlookup: a newer version of Vlookup with added features

• Duplicate remove: removes duplicate values from a table

• ERP: Enterprise Resource Planning software used for managing business processes

• SAP: Systems, ...read more