MIS Executive and Coordinator Interview Questions and Answers

Excel Google Sheet has various formulas and functions to perform calculations and automate tasks.

• Formulas are used to perform calculations on data in cells.

• Functions are pre-built formulas that can be used to perform specific tasks.

• Examples of functions include SUM, AVERAGE, IF, VLOOKUP, and CONCATENATE.

• Functions can be nested to perform more complex calculations.

• Excel Google Sheet also has array formulas that can perform calculations on multiple cells at once.

• Formulas and fu...read more

Yes, VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.

• VLOOKUP stands for 'Vertical Lookup'

• It is used to search for a value in the first column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the range B2:D10 and returns the value in the 3rd column

Yes, I have experience as an MIS Executive.

• I have 3 years of experience as an MIS Executive in a multinational company.

• I am proficient in data analysis, report generation, and database management.

• I have successfully implemented new MIS systems to improve efficiency and accuracy.

• I have strong Excel skills and have created complex spreadsheets for data analysis.

4 P's of marketing are Product, Price, Place, and Promotion.

• Product: refers to the goods or services offered by a company

• Price: refers to the amount customers pay for the product

• Place: refers to the location where the product is sold or distributed

• Promotion: refers to the marketing activities used to promote the product

The golden rule of marketing is to understand and meet the needs of the customer.

• Customer is the king

• Identify customer needs and preferences

• Create products/services that fulfill those needs

• Communicate effectively with customers

• Build long-term relationships with customers

• Examples: Apple's customer-centric approach, Amazon's personalized recommendations