Mobile Premier League Business Analyst Interview Questions and Answers

SQL query to retrieve employee names and their salaries from a table

• Use SELECT statement to retrieve data

• Specify the columns you want to retrieve (employee names and salaries)

• Specify the table name where the data is stored

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

• VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

• The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...read more