Fortune Marketing MIS Executive Interview Questions and Answers

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, Appli...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, FALSE) ...read more

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 toLocaleDat